Re: Bg_writer and checkpointer

Help me with clear information plz

On Fri, 19 Apr 2024, 20:46 Rajesh Kumar, <rajeshkumar(dot)dba09(at)gmail(dot)com>
wrote:

> 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
>