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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Can I have a look at your TuningWizard generated config file?
Дата
Msg-id 20090731141721.GA11098@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Can I have a look at your TuningWizard generated config file?  (Jennifer Trey <jennifer.trey@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Clients disconnect but query still runs
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: MSSQL to PostgreSQL