Re: Huge performance problem between 7.4.1 and 8.0.3 -

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: Huge performance problem between 7.4.1 and 8.0.3 -
Дата
Msg-id 42DB2684.9020706@zeut.net
обсуждение исходный текст
Ответ на Huge performance problem between 7.4.1 and 8.0.3 - CS issue?  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Ответы Re: Huge performance problem between 7.4.1 and 8.0.3 - CS
Список pgsql-performance
Robert Creager wrote:

>For 8.03, pg_autovacuum is running.  On 7.4.1, I set up a cron job to vacuum
>analyze every 5 minutes.
>
>

Are you sure that pg_autovacuum is doing it's job?  Meaning are you sure
it's vacuuming as often as needed?  Try to run it with -d2 or so and
make sure that it is actually doing the vacuuming needed.


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

Предыдущее
От: Robert Creager
Дата:
Сообщение: Huge performance problem between 7.4.1 and 8.0.3 - CS issue?
Следующее
От: Robert Creager
Дата:
Сообщение: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS