Re: Help interpreting pg_stat_bgwriter output

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: sam mulube <sam(dot)mulube(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Help interpreting pg_stat_bgwriter output
Date: 2009-08-19 21:46:02
Message-ID: 3073cc9b0908191446i78c7bd3dj537921c5ff835976@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 13, 2009 at 3:00 AM, Greg Smith<gsmith(at)gregsmith(dot)com> 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) lower than buffers_clean, rigth?
or i'm understanding wrong?

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sanjay Arora 2009-08-19 22:00:23 Re: Stock Market Price Data & postgreSQL? HELLPPP Please
Previous Message Sanjay Arora 2009-08-19 21:43:01 Re: Stock Market Price Data & postgreSQL? HELLPPP Please