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 <mag...@hagander.net>wrote: > On Fri, Jul 31, 2009 at 12:35, Jennifer Trey<jennifer.t...@gmail.com> > wrote: > > On Fri, Jul 31, 2009 at 12:29 PM, Thomas Kellerer <spam_ea...@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 :-) > > 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/ >
