From: | "Devi" <devi(at)visolve(dot)com> |
---|---|
To: | "Henrik" <henke(at)mac(dot)se>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Checkpoints questions |
Date: | 2008-03-04 11:11:19 |
Message-ID: | 011101c87de8$8dbf2c60$3f0110ac@devco |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Hope this helps
http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm
Thanks
DEVI.G
----- Original Message -----
From: "Henrik" <henke(at)mac(dot)se>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, March 04, 2008 3:28 PM
Subject: [GENERAL] Checkpoints questions
> Hi list,
>
> I'm using 8.3 and I've started looking at the new checkpoint features.
>
> As a starter does anyone have some clues how to analyse this:
>
> db=# select * from pg_stat_bgwriter;
> checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean
> | maxwritten_clean | buffers_backend | buffers_alloc
> -------------------+-----------------+--------------------
> +---------------+------------------+-----------------+---------------
> 118 | 435 | 1925161 | 126291
> | 7 | 1397373 | 2665693
>
>
> Thanks!
> //Henke
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition. Version: 7.5.516 / Virus Database:
> 269.21.4/1309 - Release Date: 3/3/2008 6:50 PM
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2008-03-04 12:45:35 | Re: Checkpoints questions |
Previous Message | Henrik | 2008-03-04 09:58:21 | Checkpoints questions |