Ok. I will.. when it comes to the other settings, like autovacuum and such. Could I have a look at yours ? :)
I will list the ones that I find important and that i already have figured out good values for, please fill in if there is more I should look at:
max_connections
effective_cache
random_page_cost
maintenance_work_mem
shared_buffers
work_mem
max_fsm_pages(scratched)
max_fsm_relations(scratched)
wal_buffers
But then there is the log and autovacuum stuff that I have no idea about and that believe that I could just take from someone else and not really machine dependant..
Thanks in advance / Jennifer
On Fri, Jul 31, 2009 at 12:48 PM, Magnus Hagander
<magnus@hagander.net> 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.
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 :-)
There may be other issues as well, so read up on the documentation for
anything else it recommends to change.
As for these two values, you can just ignore them - they are tuned
dynamically on 8.4.
--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.com/