Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 3E2FB2E008B
	for <pgsql-hackers-postgresql.org@developer.postgresql.org>;
	Tue, 10 Jun 2008 15:27:02 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 55892-01-2
	for <pgsql-hackers-postgresql.org@developer.postgresql.org>;
	Tue, 10 Jun 2008 15:26:52 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by developer.postgresql.org (Postfix) with ESMTP id EDFB02E0147
	for <pgsql-hackers@postgresql.org>;
	Tue, 10 Jun 2008 15:23:28 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m5AIN5xu021876;
	Tue, 10 Jun 2008 14:23:05 -0400 (EDT)
To: Josh Berkus <josh@agliodbs.com>
cc: pgsql-hackers@postgresql.org, Robert Treat <xzilla@users.sourceforge.net>,
	Peter Eisentraut <peter_e@gmx.net>, Greg Smith <gsmith@gregsmith.com>,
	Andreas Pflug <pgadmin@pse-consulting.de>, Decibel! <decibel@decibel.org>
Subject: Re: Overhauling GUCS 
In-reply-to: <200806100949.17918.josh@agliodbs.com> 
References: <48409D1E.3070208@agliodbs.com>
	<200806061624.29105.xzilla@users.sourceforge.net>
	<200806100937.38124.josh@agliodbs.com>
	<200806100949.17918.josh@agliodbs.com>
Comments: In-reply-to Josh Berkus <josh@agliodbs.com>
	message dated "Tue, 10 Jun 2008 09:49:17 -0700"
Date: Tue, 10 Jun 2008 14:23:04 -0400
Message-ID: <21875.1213122184@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200806/473
X-Sequence-Number: 119586

Josh Berkus <josh@agliodbs.com> writes:
> Oh, and wal_buffers, the default for which we should just change if it
> weren't for SHMMAX.

Uh, why?  On a workload of mostly small transactions, what value is
there in lots of wal_buffers?

			regards, tom lane