Re: Purging few months old data and vacuuming in production

Thank you very much for the response.

> Can you do online purging?

> For example, get a list of the main table's primary keys to be deleted, and
> then nibble away at them all day: in one transaction delete all the records
> for one logically related set of records.  Do that N million times, and
> you've purged the data without impacting production.

So, with this approach, is the advantage like, manual vacuuming worry may be set aside, because auto-vacuuming would deal with the dead rows? This is because the deletion step is executed record by record in main table, with its connected record(s) delete executions in rest of tables? Due to the infra capability that is there in this instance, the impact could be almost none!!??

Thank you...

This electronic mail (including any attachment thereto) may be confidential and privileged and is intended only for the individual or entity named above. Any unauthorized use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. Accordingly, if you are not the intended recipient, please notify the sender by replying to this email immediately and delete this email (and any attachment thereto) from your computer system...Thank You.