Partition big table

Moderator: NorbertKrupa

Post Reply
chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Partition big table

Post by chenshaulian » 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

chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Re: Partition big table

Post by chenshaulian » Sun Jul 17, 2016 12:12 pm

No one... ???

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Partition big table

Post by NorbertKrupa » Tue Jul 19, 2016 1:20 am

Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “Vertica Database Administration”