To: pgsql-admin@postgresql.org
connect(): No such file or directory
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Details about pg_stat_bgwriter
Date: Tue, 08 Jun 2010 17:34:03 +0200
Lines: 20
Message-ID: <hulnta$mqe$1@dough.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: 217.110.94.67
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.746 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, RCVD_NUMERIC_HELO=1.164, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201006/71
X-Sequence-Number: 34849

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