On 9/19/07, Simon Riggs <[EMAIL PROTECTED]> wrote: > > > In your last post you mentioned multiple UPDATEs. Pruning multiple times > for successive UPDATEs isn't going to release more space, so why do it? > > I guess the point is when you do the first update, there is enough free space in the page and hence we won't prune the page. We run out of free space for subsequent updates and want to prune, but now can't prune because executor is holding a pin on the buffer.
Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com