Checkpoint ; WAL

Поиск
Список
Период
Сортировка
От kenneth d'souza
Тема Checkpoint ; WAL
Дата
Msg-id BAY116-W6C878A3D0E2B7B48ED327ED0F0@phx.gbl
обсуждение исходный текст
Список pgsql-novice

Hi,

I am reading some text on checkpoint, WAL etc in PG. read the files xlog.c, bgwriter.c. I have some newbie related
questionswhich 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
againto store new data? 

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

Thanks,
Kenneth

_________________________________________________________________
Post ads for free - to sell, rent or even buy.www.yello.in
http://ss1.richmedia.in/recurl.asp?pid=186

В списке pgsql-novice по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: pg_prepare question
Следующее
От: Cliff Nieuwenhuis
Дата:
Сообщение: encoding problems