Re: 15,000 tables

Поиск
Список
Период
Сортировка
От
Тема Re: 15,000 tables
Дата
Msg-id 06f401c5f699$bbae2af0$0201a8c0@iwing
обсуждение исходный текст
Ответ на 15,000 tables  (Michael Riess <mlriess@gmx.de>)
Ответы Re: 15,000 tables  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
hi michael

>> Have you ANALYZEd your database? VACUUMing?
>
> Of course ... before 8.1 we routinely did a vacuum full analyze each
> night. As of 8.1 we use autovacuum.


what i noticed is autovacuum not working properly as it should. i had 8.1
running with autovacuum for just 2 days or so and got warnings in pgadmin
that my tables would need an vacuum. i've posted this behaviour some weeks
ago to the novice list requesting more infos on how to "tweak" autovacuum
properly - unfortunately without any respones. thats when i switched the
nightly analyze job back on - everything runs smooth since then.

maybe it helps in your case as well?

cheers,
thomas





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

Предыдущее
От: Michael Riess
Дата:
Сообщение: Re: 15,000 tables
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: pg_stat* values ...