Re: Theory question

Jayadevan M <maymala.jayadevan@gmail.com> 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