On 9/21/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > This might be a simplistic question but if the page is +90% full and > there is a long-lived transaction, isn't Postgres going to try pruning > on each page read access? > > The way it stands today, yes. Thats one reason why we are seeing the performance drop in this particular case.
I liked the earlier proposed idea of storing the xid in the page header to quickly tell us whether its worth pruning the page. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com