Re: Can I have a look at your TuningWizard generated config file? - Mailing list pgsql-general

From Ashesh Vashi
Subject Re: Can I have a look at your TuningWizard generated config file?
Date
Msg-id 4A72F604.2050602@enterprisedb.com
Whole thread Raw
In response to Re: Can I have a look at your TuningWizard generated config file?  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Can I have a look at your TuningWizard generated config file?
List pgsql-general
Hi Jennifer,

Magnus Hagander wrote:
On Fri, Jul 31, 2009 at 12:35, Jennifer Trey<jennifer.trey@gmail.com> wrote:
On Fri, Jul 31, 2009 at 12:29 PM, Thomas Kellerer <spam_eater@gmx.net>
wrote:
Jennifer Trey, 31.07.2009 12:17:
Hi,

I wanted to start with the TuningWizard and then configure the one they
suggested, thinking that I am starting from good default values.

But I am not able to run TuningWizard for some strange reason, but I am
actually mostly interested in some few settings that it usually provides.
Especially max_fsm_pages
max_fsm_relations
Which Postgres version are you using?
IIRC those settings are not longer valid for 8.4

THomas
Aha, ok. I am using 8.4. They are still to be set, confusing.
AFAICS, the edb tuning wizard has not (yet) been updated to support
PostgreSQL 8.4. The hints it gives are for 8.3 and earlier. It would
probably be a good idea if they gave a warning for that, but I take it
they don't :-)
TuningWizard (latest version 1.3) has been updated to support PostgreSQL 8.4.
As for these two values, you can just ignore them - they are tuned
dynamically on 8.4.
Agree.
It will be taken care automatically on 8.4.

--
Thanks & Regards,
Ashesh Vashi

EnterpriseDB INDIA: http://www.enterprisedb.com

pgsql-general by date:

Previous
From: Ashesh Vashi
Date:
Subject: Re: Can I have a look at your TuningWizard generated config file?
Next
From: Rich Shepard
Date:
Subject: Re: Design Database, 3 degrees of Users.