Re: Turning off HOT/Cleanup sometimes

On 15 April 2015 at 16:01, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> Simon Riggs wrote:
>> On 15 April 2015 at 12:39, Robert Haas <robertmhaas@gmail.com> wrote:
>
>> On 04/15/2015 05:44 PM, Alvaro Herrera wrote:
>> > Robert's proposal is "when reading a page, if dirty HOT-clean it; if not
>> > dirty, also HOT-clean it but only 5 times in each scan".  This runs
>> > HOT-cleanup some number of times (as many as there are dirty), and
>> > causes at most 5 pages to become dirty.
>>
>> My understanding of Robert's proposal was "when reading a page,
>> HOT-clean it, but only do this up to 5 times on clean pages, but
>> continue to do this indefinitely when the page is already dirty.".
>
> To me, both statements look identical.

I didn't read it that way, apologies for any confusion. But that is good news.

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, RemoteDBA, Training &
Services