Is autovacuum on by default? or do I uncomment #autovacuum = on
and #track_counts = on to enable it? Anything else I should do? Thanks / Jennifer On Fri, Jul 31, 2009 at 1:10 PM, Jennifer Trey <jennifer.t...@gmail.com>wrote: > 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/ >> > >
