X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 78D04D1B550
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 18:08:29 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 08757-08
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 15:07:43 -0300 (ADT)
Received: from davinci.ethosmedia.com (unknown [209.128.84.228])
	by svr1.postgresql.org (Postfix) with ESMTP id DFBD7D1B56E
	for <pgsql-performance@postgresql.org>;
	Wed,  8 Oct 2003 15:07:40 -0300 (ADT)
Received: from [63.195.55.98] (HELO spooky)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2)
	with ESMTP id 3741697; Wed, 08 Oct 2003 11:08:17 -0700
Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: Bruce Momjian <pgman@candle.pha.pa.us>
Subject: Re: PostgreSQL vs. MySQL
Date: Wed, 8 Oct 2003 11:05:47 -0700
User-Agent: KMail/1.4.3
Cc: Andrew Sullivan <andrew@libertyrms.info>, pgsql-performance@postgresql.org
References: <200310081758.h98Hwvr15088@candle.pha.pa.us>
In-Reply-To: <200310081758.h98Hwvr15088@candle.pha.pa.us>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200310081105.47527.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/228
X-Sequence-Number: 3976

Bruce,

> Yes, I think that is a good idea --- now, does it go in the install
> docs, or in the docs next to each GUC item?

Hmmm ... both, I think.   The Install Docs should have:

"Here are the top # things you will want to adjust in your PostgreSQL.conf:
1) Shared_buffers <link>
2) Sort_mem <link>
3) effective_cache_size <link>
4) random_page_cost <link>
5) Fsync <link>
etc."

Then next to each of these items in the Docs, I add 1-2 sentences about how to 
set that item.

Hmmm ... do we have similar instructions for setting connection options and 
pg_hba.conf?  We should have a P telling people they need to do this.

Barring an objection, I'll get to work on this.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco