Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id E73519FB3E6
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 26 Jun 2007 05:02:10 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 82046-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 26 Jun 2007 05:02:01 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from oxford.xeocode.com (unknown [87.127.95.196])
	by postgresql.org (Postfix) with ESMTP id BDDED9FB40E
	for <pgsql-performance@postgresql.org>;
	Tue, 26 Jun 2007 05:02:04 -0300 (ADT)
Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com)
	by oxford.xeocode.com with esmtp (Exim 4.67)
	(envelope-from <stark@enterprisedb.com>)
	id 1I35zs-0005FL-5F; Tue, 26 Jun 2007 09:02:00 +0100
From: Gregory Stark <stark@enterprisedb.com>
To: "Jim Nasby" <decibel@decibel.org>
Cc: "Greg Smith" <gsmith@gregsmith.com>,  <pgsql-performance@postgresql.org>
Subject: Re: Volunteer to build a configuration tool
In-Reply-To: <BA5FEC30-926B-4FC5-BF17-E1BECE1B6BDD@decibel.org> (Jim Nasby's
	message of "Mon, 25 Jun 2007 19:19:01 -0500")
Organization: EnterpriseDB
References: <A3AC4FA47DC0B1458C3E5396E685E63302395E53@SAB-DC1.sab.uiuc.edu>
	<1182298719.4482.133.camel@ipso.snappymail.ca>
	<Pine.GSO.4.64.0706200040001.7594@westnet.com>
	<7621.1182318230@sss.pgh.pa.us>
	<Pine.GSO.4.64.0706200224430.16657@westnet.com>
	<9001.1182323187@sss.pgh.pa.us> <op.tt7mn0m9cigqcu@apollo13>
	<Pine.GSO.4.64.0706201044100.9089@westnet.com>
	<A3AC4FA47DC0B1458C3E5396E685E63302395E6C@SAB-DC1.sab.uiuc.edu>
	<Pine.GSO.4.64.0706210244340.29867@westnet.com>
	<A3AC4FA47DC0B1458C3E5396E685E63302395E74@SAB-DC1.sab.uiuc.edu>
	<Pine.GSO.4.64.0706231522460.1349@westnet.com>
	<BA5FEC30-926B-4FC5-BF17-E1BECE1B6BDD@decibel.org>
X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.performance" 1333)
Date: Tue, 26 Jun 2007 09:01:59 +0100
Message-ID: <87odj3dtzc.fsf@oxford.xeocode.com>
User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/21.4 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/598
X-Sequence-Number: 25631

"Jim Nasby" <decibel@decibel.org> writes:

> The real issue is that the "stock" postgresql.conf is just horrible. It was
> originally tuned for something like a 486, but even the recent  changes have
> only brought it up to the "pentium era" (case in point:  24MB of shared buffers
> equates to a machine with 128MB of memory,  give or take). 

I think it's more that the stock configure has to assume it's not a dedicated
box. Picture someone installing Postgres on their debian box because it's
required for Gnucash. Even having 24M suddenly disappear from the box is quite
a bit.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com