Hi,
Hope this helps
http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm
Thanks
DEVI.G
----- Original Message -----
From: "Henrik" <henke@xxxxxx>
To: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, March 04, 2008 3:28 PM
Subject: 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
