Re: Turning off HOT/Cleanup sometimes - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Turning off HOT/Cleanup sometimes
Date
Msg-id CA+U5nMLPzTiWAbvQR0TMzns5wwkYw5vbUOGwYifju+48jYF+qQ@mail.gmail.com
Whole thread Raw
In response to Re: Turning off HOT/Cleanup sometimes  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: raw output from copy
Next
From: Pavel Stehule
Date:
Subject: Re: raw output from copy