Try this for Vertica v6.

There's an [ AT TIME 'timestamp' ] prefix for the select statement that can show what the data in a table looked like at a previous point in time.
https://my.vertica.com/docs/6.1.x/HTML/ ... tm#689.htm

I'm assuming this stops working once history for that epoch has been purged.

Found here: http://hp-vertica.com/hp-vertica-advanc ... -training/

Click on the red button labelled "Performance Tuning Exercises".

HP included the presentation in the zip file.

Thank you!

Here's an example of how to do partitioning.

http://www.vertica-forums.com/viewtopic.php?f=63&t=1113

Run this for an assessment of what your CPU's are capable of compared to their actual performance. If the cpu_frequency_mhz is lower than what the specs are calling for then you'll want to talk to your linux admin about disabling CPU frequency scaling. select node_name, processor_id, model_name, cpu...

Partition swapping is a common technique for loading data into tables. Typically you will load data into a stage table, then swap the stage table into a partition in the destination table. For large tables this is much faster than a merge, with downtime measured in seconds. Here's what I learned: 1....