Re: Theory question
От
Jeff Janes
Тема
Re: Theory question
Дата
Msg-id
CAMkU=1zuo=1MFtpTsD52f2TqBVAkzWnfH5JcU7MhVv0pLr7U1g@mail.gmail.com
Ответ на
Re: Theory question (Jayadevan)
Список
Дерево обсуждения
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 7:09 PM, Jayadevan <maymala.jayadevan@gmail.com> wrote:
Kevin Grittner-5 wrote> The checkpointer process is responsible for creating safe pointsThank you. Do both of them write to the same files?
> 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.
Yes, mostly. (The checkpointer also does some other housekeeping writes beyond the ordinary data file ones)
Is it that checkpoint
writes only committed data whereas background writer may also write
non-committed data if there is no space available in the buffers?
No. The checkpointer writes all data that was dirty as of a certain time (the start of the checkpoint) regardless of how often it was used since dirtied, and the background writer writes data that hasn't been used recently, regardless of when it was first dirtied. Neither knows or cares whether the data being written was committed, rolled back, or still in progress.
Cheers,
Jeff
В списке pgsql-general по дате отправления
От: Janek Sendrowski
Дата:
