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 25A93D1B8AE
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 18:18:38 +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 11346-06
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 15:17:53 -0300 (ADT)
Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251])
	by svr1.postgresql.org (Postfix) with ESMTP id DCAC4D1B912
	for <pgsql-performance@postgresql.org>;
	Wed,  8 Oct 2003 15:16:05 -0300 (ADT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.11.6) id h98IFw416827;
	Wed, 8 Oct 2003 14:15:58 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200310081815.h98IFw416827@candle.pha.pa.us>
Subject: Re: PostgreSQL vs. MySQL
In-Reply-To: <200310081105.47527.josh@agliodbs.com>
To: Josh Berkus <josh@agliodbs.com>
Date: Wed, 8 Oct 2003 14:15:58 -0400 (EDT)
Cc: Andrew Sullivan <andrew@libertyrms.info>, pgsql-performance@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL106 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/230
X-Sequence-Number: 3978


Totally agree.

---------------------------------------------------------------------------

Josh Berkus wrote:
> 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
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073