Re: [GENERAL] Help interpreting pg_stat_bgwriter output

2009-08-19 Thread Jaime Casanova
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)

Re: [GENERAL] Help interpreting pg_stat_bgwriter output

2009-08-13 Thread Greg Smith
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

[GENERAL] Help interpreting pg_stat_bgwriter output

2009-08-11 Thread sam mulube
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 ---+-++--