On 9/21/07, Bruce Momjian <bruce@momjian.us> 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