The Vertica Database Forums

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

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

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

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

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