Search found 149 matches
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 4:21 pm
- Forum: Vertica Performance Tuning
- Topic: How to optimize
- Replies: 6
- Views: 3950
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.
- 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: 2480
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...