Search found 149 matches

by jpcavanaugh
Fri Feb 15, 2013 3:23 pm
Forum: JDBC
Topic: JDBC driver redistribution
Replies: 2
Views: 17611

Re: JDBC driver redistribution

I can find out for you -- can you email me at joe@vertica.com and I will get back to you? Thanks!
by jpcavanaugh
Mon Jan 28, 2013 7:24 pm
Forum: vSQL
Topic: Global .vsqlrc File
Replies: 2
Views: 7922

Re: Global .vsqlrc File

I would take a look at /opt/vertica/config/vsqlrc but please be very careful editing this to make sure you do not cause issues for other scripts that might call into the default vsql (and not expecting your changes).
by jpcavanaugh
Wed Jan 23, 2013 5:33 pm
Forum: New to Vertica Database Administration
Topic: How to analyze all tables in one schema (edited)
Replies: 4
Views: 9188

Re: How to analyze all schema tables

Just give it an empty string as the argument.

Code: Select all

select analyze_statistics('');
by jpcavanaugh
Wed Jan 23, 2013 4:21 pm
Forum: Vertica Performance Tuning
Topic: How to optimize
Replies: 6
Views: 24940

Re: How to optimize

For minimums, Vertica has a 2G per core value. But I really recommend 4-8G per core. Can you check dc_execution_engine_events (order by time desc) to see if your group by is spilling to disk. Also, please let me know if you have any encoding on the projections or if you are using default projections.
by jpcavanaugh
Tue Jan 22, 2013 9:17 pm
Forum: Vertica Performance Tuning
Topic: How to optimize
Replies: 6
Views: 24940

Re: How to optimize

Have you run DBD on your table/queries? Are you seeing any spilling of the group by to disk? You are below the minimum memory requirements for Vertica as well.
by jpcavanaugh
Fri Jan 18, 2013 8:08 pm
Forum: New to Vertica Database Administration
Topic: When was a table last accessed and by whom?
Replies: 3
Views: 26538

Re: When was a table last accessed and by whom?

To simply find the last access time for a table by user -- (any access, not just select). select table_name, max(time) as last_access, user_name from dc_projections_used where is_virtual = 'f' and table_schema not like 'v_%' group by table_name, user_name order by 2,3 desc; Results are something lik...
by jpcavanaugh
Fri Jan 18, 2013 6:32 pm
Forum: New to Vertica Database Administration
Topic: What is the Initiator Node?
Replies: 3
Views: 8728

Re: What is the Initiator Node?

Thats one of the best parts of vertica - there is no main node or leader node - all nodes are equal.

Go to advanced search