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 B0239D1B4EF
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 18:29:33 +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 19230-06
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 15:28:48 -0300 (ADT)
Received: from bob.samurai.com (bob.samurai.com [205.207.28.75])
	by svr1.postgresql.org (Postfix) with ESMTP id B1091D1B549
	for <pgsql-performance@postgresql.org>;
	Wed,  8 Oct 2003 15:28:46 -0300 (ADT)
Received: from 6-allhosts (d226-85-166.home.cgocable.net [24.226.85.166])
	by bob.samurai.com (Postfix) with ESMTP
	id A5F121F4B; Wed,  8 Oct 2003 14:28:46 -0400 (EDT)
Subject: Re: PostgreSQL vs. MySQL
From: Neil Conway <neilc@samurai.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>,
	Andrew Sullivan <andrew@libertyrms.info>,
	PostgreSQL Performance <pgsql-performance@postgresql.org>
In-Reply-To: <200310081105.47527.josh@agliodbs.com>
References: <200310081758.h98Hwvr15088@candle.pha.pa.us>
	<200310081105.47527.josh@agliodbs.com>
Content-Type: text/plain
Message-Id: <1065637725.3419.30.camel@tokyo>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Wed, 08 Oct 2003 14:28:45 -0400
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/232
X-Sequence-Number: 3980

On Wed, 2003-10-08 at 14:05, Josh Berkus wrote:
> 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."

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

I think this kind of information belongs in the documentation proper,
not in the installation instructions. I think you should put this kind
of tuning information in the "Performance Tips" chapter, and include a
pointer to it in the installation instructions.

-Neil