Search found 302 matches
- Thu Feb 18, 2016 7:19 pm
- Forum: General
- Topic: Usage of AT EPOCH LATEST in VIEW
- Replies: 7
- Views: 15672
Re: Usage of AT EPOCH LATEST in VIEW
Saritha, Are your performance issues with CDC enabled because your queries are queueing on the table locks? Normally queries executed in transaction mode READ COMMITTED, which is equivalent to AT EPOCH LATEST. If your queries are queueing on the locks, that suggests that your queries are running in ...
- Wed Feb 03, 2016 2:53 pm
- Forum: Vertica Performance Tuning
- Topic: analyze_statistics on "Materialize" Step
- Replies: 5
- Views: 21747
Re: analyze_statistics on "Materialize" Step
Materialization is really just the reading of data from the projection. Query plans may choose to do “early materialization”, which means reading data from the projection during the initial projection scan, or “late materialization” which means deferring the read until a later step of the execution ...
- Thu Jan 07, 2016 7:17 pm
- Forum: Vertica User Defined Functions (UDFs)
- Topic: Thread Safety for numpy, pandas for embedded python in UDF
- Replies: 1
- Views: 15901
Re: Thread Safety for numpy, pandas for embedded python in UDF
You may want to ask this question in the HP Developer Community, where there’s more of an HP presence.
https://community.dev.hpe.com/t5/Vertic ... ms_vertica
https://community.dev.hpe.com/t5/Vertic ... ms_vertica
- Fri Dec 04, 2015 4:22 pm
- Forum: New to Vertica SQL
- Topic: Question about running multiple SQL scripts with vsql
- Replies: 6
- Views: 26548
Re: Question about running multiple SQL scripts with vsql
Does FILELIST.SQL run if you remove the \i insert.sql line? I’ll guess that there’s an error on the prevoius sql - a missing semi-colon or something similar.
- Wed Dec 02, 2015 6:51 pm
- Forum: Vertica Performance Tuning
- Topic: Queries slowdown on server load
- Replies: 5
- Views: 21922
Re: Queries slowdown on server load
You can check the dc_query_executions table to see where the time is being spent when the queries slow down - whether it’s waiting on resources, query planning, or in the actual execution.
—Sharon
—Sharon
- Fri Nov 20, 2015 7:23 pm
- Forum: Vertica Performance Tuning
- Topic: Creating Live Aggregate Projection
- Replies: 7
- Views: 34372
Re: Creating Live Aggregate Projection
Use just KSAFE at the end of the definition, not ALL NODES KSAFE.
Btw - on the vertica version number check, use “select version()”. You posted your vsql client version, which doesn’t necessarily match the server version.
—Sharon
Btw - on the vertica version number check, use “select version()”. You posted your vsql client version, which doesn’t necessarily match the server version.
—Sharon
- Thu Nov 19, 2015 7:56 pm
- Forum: Vertica Performance Tuning
- Topic: Creating Live Aggregate Projection
- Replies: 7
- Views: 34372
Re: Creating Live Aggregate Projection
Try adding KSAFE or KSAFE 1 at the end of the CREATE PROJECTION statement.
—Sharon
—Sharon