Re: Theory question
От
dinesh kumar
Тема
Re: Theory question
Дата
Msg-id
CALnrH7qJ7H-zDkfnA9+V4-QM2HqM5HW2q40Sxm1X9KqEh2UaWA@mail.gmail.com
Ответ на
Theory question (Jayadevan M)
Список
Дерево обсуждения
Theory question Jayadevan M <maymala.jayadevan@gmail.com>
Re: Theory question Kevin Grittner <kgrittn@ymail.com>
Re: Theory question Jayadevan <maymala.jayadevan@gmail.com>
Re: Theory question Jeff Janes <jeff.janes@gmail.com>
Re: Theory question Jayadevan <maymala.jayadevan@gmail.com>
Re: Theory question Jayadevan M <maymala.jayadevan@gmail.com>
Re: Theory question Raghavendra <raghavendra.rao@enterprisedb.com>
Re: Theory question dinesh kumar <dineshkumar02@gmail.com>
On Tue, Nov 12, 2013 at 6:57 AM, Jayadevan M <maymala.jayadevan@gmail.com> wrote:
I believe, "Checkpoint" is one of the responsible duty of bgwriter process. AFAIK from PG 9.2 onwards, we have another independent process called "CKPTR process" which independently works. "Bgwriter" simply move the shared_buffer's pages into local disk on the basis of LRU method. Where as "CKPTR process" moves all the dirty buffers into local disk, and make a transaction log sequence, at which all the data files have been updated to reflect this information.
Hi,What are the real differences between the bgwriter and checkpointer process? Both of them write data from the buffer to the data files, right? Is it just a matter of 'when' they write?
I believe, "Checkpoint" is one of the responsible duty of bgwriter process. AFAIK from PG 9.2 onwards, we have another independent process called "CKPTR process" which independently works. "Bgwriter" simply move the shared_buffer's pages into local disk on the basis of LRU method. Where as "CKPTR process" moves all the dirty buffers into local disk, and make a transaction log sequence, at which all the data files have been updated to reflect this information.
В списке pgsql-general по дате отправления
От: Francisco Figueiredo Jr.
Дата:
