[GENERAL] Checkpoints questions

2008-03-04 Thread Henrik
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 |

Re: [GENERAL] Checkpoints questions

2008-03-04 Thread Devi
Hi, Hope this helps http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm Thanks DEVI.G - Original Message - From: Henrik [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Tuesday, March 04, 2008 3:28 PM Subject: [GENERAL] Checkpoints questions Hi list, I'm using

Re: [GENERAL] Checkpoints questions

2008-03-04 Thread Greg Smith
On Tue, 4 Mar 2008, Henrik wrote: 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

Re: [GENERAL] Checkpoints questions

2008-03-04 Thread Henrik
4 mar 2008 kl. 13.45 skrev Greg Smith: On Tue, 4 Mar 2008, Henrik wrote: 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 |