Best practice for deleting huge amount of data

Moderator: NorbertKrupa

Post Reply
caprile
Newbie
Newbie
Posts: 13
Joined: Tue May 29, 2012 1:24 pm

Best practice for deleting huge amount of data

Post by caprile » Tue May 29, 2012 9:44 pm

Hi,
anyone knows if there is a best practice for deleting huge amount of data in Vertica 5.1.x?
My needs is to delete huge amount of data and at same time execute massive query, but i think that I will have performance decreasing during select statement executiion.

Thanks in advance

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: Best practice for deleting huge amount of data

Post by jpcavanaugh » Thu May 31, 2012 7:12 pm

Is your table partitioned? Are your deletes within a set of partitions?

caprile
Newbie
Newbie
Posts: 13
Joined: Tue May 29, 2012 1:24 pm

Re: Best practice for deleting huge amount of data

Post by caprile » Tue Jun 12, 2012 4:31 pm

No, I have a plain table.
I suppose if I create table partitioned i lost the data compression of vertica.

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: Best practice for deleting huge amount of data

Post by jpcavanaugh » Tue Jun 12, 2012 8:57 pm

Partitioning will not have compression issues - I would suggest to use it if it makes sense for delete situations. As far as best practices there are a couple and they are documented here.

http://my.vertica.com/docs/6.0.0/HTML/i ... #12703.htm

caprile
Newbie
Newbie
Posts: 13
Joined: Tue May 29, 2012 1:24 pm

Re: Best practice for deleting huge amount of data

Post by caprile » Tue Jun 12, 2012 9:34 pm

Thank you very much...
I will study this documentation...

Post Reply

Return to “JDBC”