Re: Just-in-time Background Writer Patch+Test Results

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Just-in-time Background Writer Patch+Test Results
Дата
Msg-id 8063.1189127333@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Just-in-time Background Writer Patch+Test Results  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> On Thu, Sep 6, 2007 at 11:27 AM, in message
> <Pine.GSO.4.64.0709061121020.14491@westnet.com>, Greg Smith
> <gsmith@gregsmith.com> wrote: 
>> With the default delay of 200ms, this has the LRU-writer scanning the 
>> whole pool every 1 second,
>  
> Whoa!  Apparently I've totally misread the documentation.  I thought that
> the bgwriter_lru_percent was scanned from the lru end each time; I would
> not expect that it would ever get beyond the oldest 10%.

I believe you're correct and Greg got this wrong.  I won't draw any
conclusions about whether the LRU stuff is actually doing you any good
though.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)
Следующее
От: Tom Lane
Дата:
Сообщение: Low hanging fruit in lazy-XID-assignment patch?