On Thu, Aug 13, 2009 at 3:00 AM, Greg Smith wrote:
>
>> buffers_backend = 740
>
> This number represents the behavior the background writer is trying to
> prevent--backends having to clean their own buffers up.
>
so what we want on busy systems is buffers_backend to be (at least)
equal or (better)
On Wed, 12 Aug 2009, sam mulube wrote:
is my interpreting of buffers_clean = 0 correct?
Yes.
If so, why would the bgwriter not be writing out any buffers?
The purpose of the cleaner is to prepare buffers that we expect will be
needed for allocations in the near future. Let's do a littl
Hello all,
I wonder if I could have some help interpreting the output of
pg_stat_bgwriter. Here's my output:
checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean |
maxwritten_clean | buffers_backend | buffers_alloc
---+-++--