Re: ASSM bug: slow INSERT after uncomitted DELETE
From: Mladen Gogala <mladen_at_bogus.email.invalid>
Date: Wed, 12 Aug 2009 22:17:31 +0000 (UTC)
Message-ID: <h5vf1r$nnq$2_at_solani.org>
On Mon, 10 Aug 2009 20:37:35 -0700, Noons wrote:
Date: Wed, 12 Aug 2009 22:17:31 +0000 (UTC)
Message-ID: <h5vf1r$nnq$2_at_solani.org>
On Mon, 10 Aug 2009 20:37:35 -0700, Noons wrote:
> Perhaps even more significantly, if you delete only a portion of the
> table instead of the lot, then the second session's insert is not
> affected. Normally, I would expect anyone wanting to clear a table to
> truncate it, as opposed to deleting all rows: truncate is far more
> efficient.
Unfortunately, in the situations where you want to delete everything older than 60 days, truncate is not an option.
-- http://mgogala.freehostia.comReceived on Wed Aug 12 2009 - 17:17:31 CDT