From: Heikki Linnakangas <heikki@enterprisedb.com>
To: smiley2211 <smiley2211@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql.conf Settings
Date: Sun, 04 Nov 2007 19:30:12 +0000
Message-ID: <472E1DC4.6090600@enterprisedb.com> (raw)
In-Reply-To: <13575017.post@talk.nabble.com>
References: <13575017.post@talk.nabble.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: heikki@enterprisedb.com, smiley2211@yahoo.com
Subject: Re: Postgresql.conf Settings
In-Reply-To: <472E1DC4.6090600@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox