How is interpreted the difference between postgres buffers_alloc and sum of buffers_backend, buffers_clean, buffers_checkpoint?

129 Views Asked by At

When checking pg_stat_bgwriter in postgres, I am noticing that there is a difference between buffers_alloc and the sum of buffers_backend, buffers_clean and buffers_checkpoint.

What could be assumed as a "good" percentage of total buffers written = (buffers_backend + buffers_clean + buffers_checkpoint) over buffers_alloc ?

Which settings should be tuned to optimise this percentage?

0

There are 0 best solutions below