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.


Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com

Reply via email to