Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)

Поиск
Список
Период
Сортировка
От Bastian Voigt
Тема Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Дата
Msg-id 4656C411.8010509@bastian-voigt.de
обсуждение исходный текст
Ответ на Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)  (Richard Huxton <dev@archonet.com>)
Ответы Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)  (Richard Huxton <dev@archonet.com>)
Список pgsql-performance
Richard Huxton wrote:
>
> I was about to say that you can tune pg_autovacuum, but I just checked
> your original post and you're running 8.0.x - not sure about that one.
The system catalog pg_autovacuum which allows finetuning autovacuum at
table level was introduced in 8.1 :-(

> You'll have to check the documentation for that version to see if you
> can either:
> 1. exclude that table from pg_autovacuum
> 2. increase pg_autovacuum's sensitivity
(1) seems to be impossible (correct me if I'm wrong..), so maybe I'll go
for (2) ...

> If not, and this table is the most active, it might be simpler just to
> run your own vacuum-ing from a cron job.
Well, it is one of the most active, but there are others. pg_autovacuum
seems to do a very good job, apart from this one table...


--
Bastian Voigt
Neumünstersche Straße 4
20251 Hamburg
telefon +49 - 40  - 67957171
mobil   +49 - 179 - 4826359



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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)