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

From Alvaro Herrera
Subject Re: Turning off HOT/Cleanup sometimes
Date
Msg-id 20150415200115.GG4369@alvh.no-ip.org
Whole thread Raw
In response to Re: Turning off HOT/Cleanup sometimes  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Turning off HOT/Cleanup sometimes
List pgsql-hackers
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.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Turning off HOT/Cleanup sometimes
Next
From: Peter Eisentraut
Date:
Subject: Re: raw output from copy