logo       

Re: [GENERAL] Can I have a look at your TuningWizard generated config file?: msg#01398

pgsql-general

Subject: Re: [GENERAL] Can I have a look at your TuningWizard generated config file?

Jennifer Trey escribió:
> I think I got everything now. Most things where on by default it seems.
>
>
> #------------------------------------------------------------------------------
> # RUNTIME STATISTICS
> #------------------------------------------------------------------------------
>
> # - Query/Index Statistics Collector -
>
> track_activities = off *#I turned this off

What for?

> #autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before
> vacuum
> #autovacuum_analyze_scale_factor = 0.1 # fraction of table size before
> analyze

Hmm, does the tuning wizard not touch these?

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Google Custom Search

News | Mail Home | sitemap | FAQ | advertise