Skip site navigation (1) Skip section navigation (2)

Checkpoint ; WAL

From: kenneth d'souza <kd_souza(at)hotmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Checkpoint ; WAL
Date: 2008-03-11 11:04:50
Message-ID: BAY116-W6C878A3D0E2B7B48ED327ED0F0@phx.gbl (view raw, whole thread or download thread mbox)
Lists: pgsql-novice


I am reading some text on checkpoint, WAL etc in PG. read the files xlog.c, bgwriter.c. I have some newbie related questions which I am confused with. Appreciate if someone can throw more light.

The bgwriter is associated in writing the dirty buffers to the disk very so often.
Question : Does this write happen to the ( Xlog file and the data file ) or ( to the Xlog file only ) ?

Does the bgwriter mark the "dirty" buffer ( clean,free,...) after being written to the disk so that it can be used once again to store new data?

Apart from Checkpoint is there any point at which dirty buffers are written to the data file?


Post ads for free - to sell, rent or even

pgsql-novice by date

Next:From: Cliff NieuwenhuisDate: 2008-03-11 15:10:15
Subject: encoding problems
Previous:From: John DeSoiDate: 2008-03-09 23:24:02
Subject: Re: pg_prepare question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group