Re: RC2 and open issues

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: RC2 and open issues
Дата
Msg-id 87oegmfhfb.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: RC2 and open issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: RC2 and open issues
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Maybe we need a hybrid approach: clean a few percent of the LRU end of
> the ARC list in order to keep backends from blocking on writes, plus run
> a clock scan to keep checkpoints from having to do much.  

Well if you just keep note of when the last clock scan started then when you
get to the end of the list you've _done_ a checkpoint.

Put another way, we already have such a clock scan, it's called checkpoint.
You could have checkpoint delay between each page write long enough to spread
the checkpoint i/o out over a configurable amount of time -- say half the
checkpoint interval -- and be done with that side of things.

-- 
greg



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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Thoughts about updateable views
Следующее
От: Tom Lane
Дата:
Сообщение: Re: strcoll_l an new approach for locale per column