"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Bruce Momjian 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?
> Yes :( It shouldn't, though --- the hint bit should get cleared on the first try. I think I probably broke something in the last round of revisions to heap_page_prune_opt, but haven't looked yet ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate