From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-admin@postgresql.org
Subject: Details about pg_stat_bgwriter
Date: Tue, 08 Jun 2010 17:34:03 +0200
Message-ID: <hulnta$mqe$1@dough.gmane.org> (raw)
Hi,
I'm trying to understand the information shown in pg_stat_bgwriter.
If I want to identify a possible bottleneck with the bgwriter, for what kind of numbers do I need to watch out?
Are the following values OK, or do they indicate that I need to tune my configuration?
checkpoints_timed : 6099
checkpoints_req : 291
buffers_checkpoint : 2767641
buffers_clean : 4522
maxwritten_clean : 1
buffers_backend : 609933
buffers_alloc : 1411947
I have read Greg's description (http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm), but to be honest I don't understand the explanation. He mentions a "LRU background writer", but I'm not sure to which column that relates.
Thanks in advance.
Thomas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: spam_eater@gmx.net
Subject: Re: Details about pg_stat_bgwriter
In-Reply-To: <hulnta$mqe$1@dough.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox