bgwriter and checkpoints

Поиск
Список
Период
Сортировка
От Henry Francisco Garcia Cortez
Тема bgwriter and checkpoints
Дата
Msg-id CAJP2v3E4vNx8CBsnt7W4ACs7ujk-ZmvBTCpSjamQRRYPmRLAOw@mail.gmail.com
обсуждение исходный текст
Ответы Re: bgwriter and checkpoints  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: bgwriter and checkpoints  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Hi community, I was reading about background writer process and checkpoints, but I still don't understand very well. How do they work for instance I understand this if a row was updated,those changes will be on shared buffers, then those changes will go to path on disk called pg_wall, then when a checkpoint will be executed and finally, those changes will go to data files when bgwriter process will be executed but I found a blog on internet they say that after each search, the BGWRITER chooses some number of modified pages, writes them to disk, and evicts those pages from the shared buffer pool. 




--
Ing. Henry G. Cortez



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

Предыдущее
От: Swati Patil
Дата:
Сообщение: Standby.signal file is not getting deleted after failover in all scanarios
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: bgwriter and checkpoints