Im trying migrate a PostgreSql Database to Vertica, my database have 550 GB of data, I am using DBeaver to do that, but the process is slow and complicated for some incompatible DBeaver reasons, someone know another tool to accomplish this ? Thanks. Export your DDL objects definition out of Postgre...

Wrong answer ! I totally misread your question.

I've created a SQL Script to capture what is in the v_monitor.query_requests table, which keeps a rolling history of queries and their run times. Since this table keeps a rolling history, it needs to be backed up to another history table for long term storage on a regular basis. Great solution ! Wh...

MC performs poorly enough without adding all that extra retention on DC tables ;-) > I haven't seen much interest in historical performance As someone who troubleshoots and tunes clusters on a daily basis, having history is key. All sorts of history. —Sharon That is so true, in most of the cases th...

Thank you Norbert,
I think this would be a nice feature to be added in Vertica Management Console.

Hi all,

I am trying to create some kind of baseline in Vertica so i can see how my cluster is doing in the long run and also have a better idea of how new modules.
Is there anybody who did this in the past or you guys have some general rules on how i can do this ?
Thank all.

knicely87 wrote:Check out this great paper titled "Vertica Performance Engineering Essentials"

http://davidjyoung.com/cmg/vpee.pdf

Very good paper !
Thank you Jim !