Merge vs SWAP_PARTITIONS

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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file