Re: [GENERAL] How to know which queries are to be optimised?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: [GENERAL] How to know which queries are to be optimised?
Дата
Msg-id 20040812220716.J82695-100000@houston.familyhealth.com.au
обсуждение исходный текст
Ответ на Re: [GENERAL] How to know which queries are to be optimised?  (Ulrich Wisser <ulrich.wisser@relevanttraffic.se>)
Список pgsql-performance
Дерево обсуждения 
> I do a vacuum full analyze every night.
> How can I see if my FSM setting is appropriate?

On a busy website, run vacuum analyze once an hour, or even better, use
contrib/pg_autovacuum

Chris

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Hardware upgrade for a high-traffic database
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: [GENERAL] How to know which queries are to be optimised?