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 по дате отправления: