From: | Henry Francisco Garcia Cortez <garcortez(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | alvherre(at)2ndquadrant(dot)com |
Subject: | bgwriter and checkpoints |
Date: | 2021-09-03 20:56:29 |
Message-ID: | CAJP2v3E4vNx8CBsnt7W4ACs7ujk-ZmvBTCpSjamQRRYPmRLAOw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
https://flylib.com/books/en/2.290.1/the_postgresql_bgwriter_process.html
--
Ing. Henry G. Cortez
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2021-09-03 21:22:09 | Re: bgwriter and checkpoints |
Previous Message | Andres Freund | 2021-09-03 20:20:59 | Re: Estimating HugePages Requirements? |