Re: Can I have a look at your TuningWizard generated config file? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Can I have a look at your TuningWizard generated config file?
Date
Msg-id 20090731141721.GA11098@alvh.no-ip.org
Whole thread Raw
In response to Re: Can I have a look at your TuningWizard generated config file?  (Jennifer Trey <jennifer.trey@gmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Clients disconnect but query still runs
Next
From: Merlin Moncure
Date:
Subject: Re: MSSQL to PostgreSQL