Jayadevan M <maymala.jayade...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
