bgwriter and checkpoints

Поиск
Список
Период
Сортировка
От Henry Francisco Garcia Cortez
Тема bgwriter and checkpoints
Дата
Msg-id CAJP2v3E4vNx8CBsnt7W4ACs7ujk-ZmvBTCpSjamQRRYPmRLAOw@mail.gmail.com
обсуждение исходный текст
Ответы Re: bgwriter and checkpoints
Re: bgwriter and checkpoints
Список 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 по дате отправления: