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.
