Re: Checkpoint versus Background Writer

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Checkpoint versus Background Writer
Дата
Msg-id 28364.1388276006@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Checkpoint versus Background Writer  (Sergey Konoplev <gray.ru@gmail.com>)
Список pgsql-novice
Sergey Konoplev <gray.ru@gmail.com> writes:
> On Fri, Dec 27, 2013 at 11:46 AM, Shiv Sharma
> <shiv.sharma.1835@gmail.com> wrote:
>> They seem to do similar things: clear dirty buffers from shared_buffers to
>> disk.
>>
>> So why have 2 processes with seperate semantics (seperate set of config
>> partms) ?

> AFAIU, they serve for completely different purposes.

We used to have a single process trying to serve both purposes, but
it didn't work tremendously well, because the criteria for when to
flush buffers are so different.

            regards, tom lane


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

Предыдущее
От: Sergey Konoplev
Дата:
Сообщение: Re: Checkpoint versus Background Writer
Следующее
От: Sameer Kumar
Дата:
Сообщение: Query on v9.3 Architecture independent Streaming