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
Best practice for deleting huge amount of data
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 149
- Joined: Mon Apr 30, 2012 10:04 pm
- Location: New York
- Contact:
Re: Best practice for deleting huge amount of data
Is your table partitioned? Are your deletes within a set of partitions?
Re: Best practice for deleting huge amount of data
No, I have a plain table.
I suppose if I create table partitioned i lost the data compression of vertica.
I suppose if I create table partitioned i lost the data compression of vertica.
-
- Intermediate
- Posts: 149
- Joined: Mon Apr 30, 2012 10:04 pm
- Location: New York
- Contact:
Re: Best practice for deleting huge amount of data
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
http://my.vertica.com/docs/6.0.0/HTML/i ... #12703.htm
Re: Best practice for deleting huge amount of data
Thank you very much...
I will study this documentation...
I will study this documentation...