Re: Theory question
От
Kevin Grittner
Тема
Re: Theory question
Дата
Msg-id
1384280688.49523.YahooMailNeo@web162903.mail.bf1.yahoo.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>
Jayadevan M wrote: > 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? The checkpointer process is responsible for creating safe points from which a recovery can begin; the background writer tries to keep some pages available for re-use so that processes running queries don't need to wait for page writes in order to have free spots to use in shared buffers. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-general по дате отправления
От: Brian Crowell
Дата:
От: Francisco Figueiredo Jr.
Дата:
