Subject | Re: delete with gc pain |
---|---|
Author | Adam |
Post date | 2007-01-24T10:58:22Z |
> I have a process which does a daily mass delete, I want it to alsoCommit here.
> take all the GC pain. Am I right that if I do
>
> delete from ....
Now you need to wait for all transactions that could have been
interested in the record versions prior to the delete to end (ie
commit/rollback).
Now nothing else is interested, the next transaction to read the
record is given the task of cleaning it up, so your next line is fine
> select count(*) from ...Remember to commit here.
Adam