| From: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Bg_writer and checkpointer |
| Date: | 2024-04-19 15:16:36 |
| Message-ID: | CAJk5AtaaMWLHXFyaUk36Pg7OQ8q=CcsqDXgp9hrF0jqv=HuwFg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I have read multiple online blogs, watched videos and still not clarified
about 1. Actual difference between bg_writer and checkpointer. When I am
querying update set, If bgwriter flushes dirty buffer to base every
200ms(bgwriter_delay), why would I need checkpointer to invoke bgwriter?
Same way, what happens for insert query?
1. How the flow works?
Dml-->wal_buffer-->also copied to shared_buffer--> commit-->flushed to
pg_wal using wal writer -->checkpointer-->fsync to datapath-->bgwriter
flushed to base.
Correct me the flowchart
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Murthy Nunna | 2024-04-19 17:02:41 | Intermittent Query Performance Issue |
| Previous Message | Ravindranathan Rinilnath (Ext. - UniCredit) | 2024-04-19 00:58:20 | RE: Installation of PostGIS without internet or with limited internet access |