Search found 302 matches

by scutter
Thu Feb 18, 2016 7:19 pm
Forum: General
Topic: Usage of AT EPOCH LATEST in VIEW
Replies: 7
Views: 15557

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 ...
by scutter
Wed Feb 03, 2016 2:53 pm
Forum: Vertica Performance Tuning
Topic: analyze_statistics on "Materialize" Step
Replies: 5
Views: 21512

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 ...
by scutter
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: 15733

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
by scutter
Fri Dec 04, 2015 4:22 pm
Forum: New to Vertica SQL
Topic: Question about running multiple SQL scripts with vsql
Replies: 6
Views: 25713

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.
by scutter
Wed Dec 02, 2015 6:51 pm
Forum: Vertica Performance Tuning
Topic: Queries slowdown on server load
Replies: 5
Views: 21654

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
by scutter
Fri Nov 20, 2015 7:23 pm
Forum: Vertica Performance Tuning
Topic: Creating Live Aggregate Projection
Replies: 7
Views: 34054

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
by scutter
Thu Nov 19, 2015 7:56 pm
Forum: Vertica Performance Tuning
Topic: Creating Live Aggregate Projection
Replies: 7
Views: 34054

Re: Creating Live Aggregate Projection

Try adding KSAFE or KSAFE 1 at the end of the CREATE PROJECTION statement.

—Sharon

Go to advanced search