Checkpoints questions

[Henrik <henke(at)mac(dot)se>]

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