Re: Turning off HOT/Cleanup sometimes

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