Re: Turning off HOT/Cleanup sometimes

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Turning off HOT/Cleanup sometimes
Дата
Msg-id 20150415200115.GG4369@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Turning off HOT/Cleanup sometimes  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Turning off HOT/Cleanup sometimes  (Simon Riggs <simon@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Turning off HOT/Cleanup sometimes
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: raw output from copy