Search found 149 matches
- Fri Feb 15, 2013 3:23 pm
- Forum: JDBC
- Topic: JDBC driver redistribution
- Replies: 2
- Views: 18557
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!
- Mon Jan 28, 2013 7:24 pm
- Forum: vSQL
- Topic: Global .vsqlrc File
- Replies: 2
- Views: 8064
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).
- 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: 9456
Re: How to analyze all schema tables
Just give it an empty string as the argument.
Code: Select all
select analyze_statistics('');
- Wed Jan 23, 2013 4:21 pm
- Forum: Vertica Performance Tuning
- Topic: How to optimize
- Replies: 6
- Views: 26864
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.
- Tue Jan 22, 2013 9:17 pm
- Forum: Vertica Performance Tuning
- Topic: How to optimize
- Replies: 6
- Views: 26864
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.
- 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: 27582
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...
- Fri Jan 18, 2013 6:32 pm
- Forum: New to Vertica Database Administration
- Topic: What is the Initiator Node?
- Replies: 3
- Views: 8901
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.