Partition big table
Posted: Wed Jul 13, 2016 2:26 pm
Hi all
Vertica 7.1.1-10, 20 node cluster.
We have big table (27TB) on production environment, and I want to partition this table so I could run large deletions and get this table smaller.
- What do I need to know about partitioning big table?
- What are the preparations\ checks that I need to make?
- What is the overhead?
- Anything that can help
Thanks
Chen
Vertica 7.1.1-10, 20 node cluster.
We have big table (27TB) on production environment, and I want to partition this table so I could run large deletions and get this table smaller.
- What do I need to know about partitioning big table?
- What are the preparations\ checks that I need to make?
- What is the overhead?
- Anything that can help
Thanks
Chen