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 6D4FAD1B4EF
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 19:58:48 +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 31760-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 16:58:04 -0300 (ADT)
Received: from lorax.kcilink.com (lorax.kciLink.com [206.112.95.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 90B38D1B4F6
	for <pgsql-performance@postgresql.org>;
	Wed,  8 Oct 2003 16:58:02 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by lorax.kcilink.com (Postfix) with ESMTP id 5E6963E4F
	for <pgsql-performance@postgresql.org>;
	Wed,  8 Oct 2003 15:58:04 -0400 (EDT)
Received: from lorax.kcilink.com ([127.0.0.1])
	by localhost (lorax.kcilink.com [127.0.0.1]) (amavisd-new, port 10024)
	with LMTP id 11240-04 for <pgsql-performance@postgresql.org>;
	Wed,  8 Oct 2003 15:58:03 -0400 (EDT)
Received: from lorax.kciLink.com (localhost [127.0.0.1])
	by lorax.kcilink.com (Postfix) with ESMTP id BCF8A3E29
	for <pgsql-performance@postgresql.org>;
	Wed,  8 Oct 2003 15:58:03 -0400 (EDT)
Received: (from news@localhost)
	by lorax.kciLink.com (8.12.8p1/8.12.8/Submit) id h98Jw3GX047266
	for pgsql-performance@postgresql.org;
	Wed, 8 Oct 2003 15:58:03 -0400 (EDT)
To: pgsql-performance@postgresql.org
Path: not-for-mail
From: Vivek Khera <khera@kcilink.com>
Newsgroups: ml.postgres.performance
Subject: Re: PostgreSQL vs. MySQL
Date: Wed, 08 Oct 2003 15:58:03 -0400
Organization: Khera Communications, Inc., Rockville, MD
Lines: 31
Message-ID: <x7ekxno62c.fsf@yertle.int.kciLink.com>
References: <200310081758.h98Hwvr15088@candle.pha.pa.us>
	<200310081105.47527.josh@agliodbs.com>
NNTP-Posting-Host: yertle.kcilink.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Trace: lorax.kcilink.com 1065643083 62005 216.194.193.105 (8 Oct 2003
	19:58:03 GMT)
X-Complaints-To: daemon@kciLink.com
NNTP-Posting-Date: Wed, 8 Oct 2003 19:58:03 +0000 (UTC)
User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Portable Code,
	berkeley-unix)
Cancel-Lock: sha1:x1HKMaRamIUKEqGvtQLajaYkiT8=
X-Virus-Scanned: by amavisd-new at kciLink.com
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/246
X-Sequence-Number: 3994

>>>>> "JB" == Josh Berkus <josh@agliodbs.com> writes:

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

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

Add:

max_fsm_relations (perhaps it is ok with current default)
max_fsm_pages

I don't think you really want to diddle with fsync in the name of
speed at the cost of safety.

and possibly:

checkpoint_segments (if you do a lot of writes to the DB for extended
                    durations of time)  With 7.4 it warns you in the
                    logs if you should increase this.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/