Re: HOT is applied - Mailing list pgsql-hackers

From Tom Lane
Subject Re: HOT is applied
Date
Msg-id 28384.1190384954@sss.pgh.pa.us
Whole thread Raw
In response to Re: HOT is applied  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: HOT is applied
Re: HOT is applied
List pgsql-hackers
"Heikki Linnakangas" <heikki@enterprisedb.com> 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


pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: HOT is applied
Next
From: "Pavan Deolasee"
Date:
Subject: Re: HOT is applied