The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.


Hi, dear Vertica community!

I have a table with accounts data (3,5kk rows) that updates from sources every 3 hours. As soon as update is quite slow operation, it takes about 1,5 hours to check and update changed rows.
So I would like to try inserting full actual data to temporary table and than SWAP_PARTITIONS_BETWEEN_TABLES() or RENAME to replace data in main table, that should be faster.

The concern is - what happens to users' queries at the moment of SWAP_PARTITIONS / RENAME execution? Will the queries be canceled / rerun or the users might get inconsistent information?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.