Search Postgresql Archives

Re: Can I have a look at your TuningWizard generated config file?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx> wrote:
On Fri, Jul 31, 2009 at 12:35, Jennifer Trey<jennifer.trey@xxxxxxxxx> wrote:
> On Fri, Jul 31, 2009 at 12:29 PM, Thomas Kellerer <spam_eater@xxxxxxx>
> 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 :-)

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/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux