On Wed, 2007-07-04 at 14:31 -0400, Jan Wieck wrote:
> What I see here is that we are trying to come up with a special case 
> optimization for mass-deletes. No mass insert or update operations will 
> benefit from any of this. Do people do mass deletes that much that we 
> really have to worry about them?
> 


Yes, there are a few places that I can think of where we would directly
benefit from this.  Trimming data from very active log tables is the
main case.  We also recently had a case where we needed to delete a fair
amount of data from a table quickly to prevent degraded performance in a
front line system.  We ended up dropping the table, deleting and
re-subbing. We were not is a situation where we could have done smaller
batches that slony would have liked.

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.