Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id DD46C9F9458
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sun,  4 Nov 2007 15:30:26 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 46855-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sun,  4 Nov 2007 15:30:17 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168])
	by postgresql.org (Postfix) with ESMTP id 555EC9F9454
	for <pgsql-performance@postgresql.org>;
	Sun,  4 Nov 2007 15:30:19 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id j3so829621ugf
	for <pgsql-performance@postgresql.org>;
	Sun, 04 Nov 2007 11:30:18 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender;
	bh=NRgqba9qOzW+yQ/FCkDe3mgoERWYG3973MVD7B2pVSg=;
	b=qIuHIT0icsLiKyQfy/XkZ7LNZD5jcyvLZy+h5KMiBDocgzX/voduS7VBuDQx97q/wRSV75vZm69WFxjgMG7qrszL5rbf6dXYHwHTS1SlwqZZA3ykd2KoXcaMCLm1T96zLnTieKBB3DaW1+N76cAOg6uBUpDYvg7PMcGHOs/mlvo=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender;
	b=C023+/hm7QuOFjQy5oZ5LB7fEAU/vPpcP9/8vUNkmE3YMrorDdo4b1SG7djqgYJgJYqYq4t4ofj3UBT+hHD7AHbNsQqxN6XL5FUK5uh5bIuohaPCSoP722XilW7dzYGsAXpNkXxxrKI/Ka5KgctUpGEoWKhgMrO3Y5ahGx4ZMVU=
Received: by 10.67.27.3 with SMTP id e3mr159495ugj.1194204618141;
	Sun, 04 Nov 2007 11:30:18 -0800 (PST)
Received: from ?192.168.1.33? ( [81.109.220.39])
	by mx.google.com with ESMTPS id i4sm9886202nfh.2007.11.04.11.30.14
	(version=SSLv3 cipher=RC4-MD5); Sun, 04 Nov 2007 11:30:16 -0800 (PST)
Message-ID: <472E1DC4.6090600@enterprisedb.com>
Date: Sun, 04 Nov 2007 19:30:12 +0000
From: Heikki Linnakangas <heikki@enterprisedb.com>
User-Agent: Icedove 1.5.0.12 (X11/20070730)
MIME-Version: 1.0
To: smiley2211 <smiley2211@yahoo.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Postgresql.conf Settings
References: <13575017.post@talk.nabble.com>
In-Reply-To: <13575017.post@talk.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/50
X-Sequence-Number: 27465

smiley2211 wrote:
> What are the ideal settings for values in this postgresql.conf file???  I
> have tried so many parameter changes but I still can not get the 8.1.4
> version to perform as well as the 7.x version...what do others have their
> postgrsql.conf file values set to???
> 
> Are there any known performance degrades going from 7.x to 8.1 versions???

Before spending any more time on tuning, upgrade at the very least to 
the latest 8.1.X version. Or since you're upgrading anyway, why not 
upgrade to latest 8.2.X version while you're at it. There's been plenty 
of planner changes between those releases.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com