We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Merge vs SWAP_PARTITIONS — Vertica Forum

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