Re: autovacuum: recommended?

Поиск
Список
Период
Сортировка
От tv@fuzzy.cz
Тема Re: autovacuum: recommended?
Дата
Msg-id 61575.212.24.144.68.1195220303.squirrel@mail.fuzzy.cz
обсуждение исходный текст
Ответ на Re: autovacuum: recommended?  (Tobias Brox <tobias@nordicbet.com>)
Ответы Re: autovacuum: recommended?  (Tobias Brox <tobias@nordicbet.com>)
Re: autovacuum: recommended?  (Decibel! <decibel@decibel.org>)
Список pgsql-performance
> That being said, we have some huge tables in our database and pretty
> much traffic, and got quite some performance problems when the
> autovacuum kicked in and started vacuuming those huge tables, so we're
> currently running without.  Autovacuum can be tuned to not touch those
> tables, but we've chosen to leave it off.

We had some performance problems with the autovacuum on large and
frequently modified tables too - but after a little bit of playing with
the parameters the overall performance is much better than it was before
the autovacuuming.

The table was quite huge (say 20k of products along with detailed
descriptions etc.) and was completely updated and about 12x each day, i.e.
it qrew to about 12x the original size (and 11/12 of the rows were dead).
This caused a serious slowdown of the application each day, as the
database had to scan 12x more data.

We set up autovacuuming with the default parameters, but it interfered
with the usual traffic - we had to play a little with the parameters
(increase the delays, decrease the duration or something like that) and
now it runs much better than before. No nightly vacuuming, no serious
performance degradation during the day, etc.

So yes - autovacuuming is recommended, but in some cases the default
parameters have to be tuned a little bit.

tomas


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

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: autovacuum: recommended?
Следующее
От: "Dave Dutcher"
Дата:
Сообщение: Re: PostgreSQL vs MySQL, and FreeBSD