Checkpoints questions

From: Henrik <henke(at)mac(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Checkpoints questions
Date: 2008-03-04 09:58:21
Message-ID: 55C8BA3B-AB11-4F2F-A6BC-EB46F407FF4F@mac.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devi 2008-03-04 11:11:19 Re: Checkpoints questions
Previous Message Devrim GÜNDÜZ 2008-03-04 05:56:47 Re: Build 8.3 with OpenSSL on CentOS 5.x?