I can’t understand the statistics I get from pg_stat_bgwriter.
If you believe these statistics, then the background process (bgwriter) does not clear the RAM from dirty buffers, unlike the checkpoint. If I understood correctly, then the background process should simultaneously clear the RAM of dirty buffers, if any.
My background process settings are set to default:
show bgwriter_delay = 200ms
show bgwriter_lru_max pages = 100
show bgwriter_lru_multiplier = 2
The checkpoint is performed every 20 minutes.
At the same time, sometimes the background process (bgwriter) clears data from RAM, but it does this quite rarely, i.e. it works. Should I be worried about this?