Re: Manual vacs 5x faster than autovacs?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Manual vacs 5x faster than autovacs?
Дата
Msg-id 24025.1258037392@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Manual vacs 5x faster than autovacs?  (Wayne Beaver <wayne@acedsl.com>)
Список pgsql-performance
Wayne Beaver <wayne@acedsl.com> writes:
> Running Pg 8.3RC2, Linux server, w/8GB RAM, OpenSuSE 10.2 OS (yes, I
> know that's old). I have seen *really* long-running autovacs eating up
> system resources. While the below is not an example of *really* long,
> it shows how I killed an autovac which had been running for more than
> 10 minutes, then ran a VAC FULL ANALYZE on same exact table in about
> ~2 min. Any wisdom here? Attributable to autovac_worker settings?

autovacuum_vacuum_cost_delay.  Is the slow autovac *really* eating
a noticeable amount of system resources?  I would think that a full
speed manual vacuum would be a lot worse.

            regards, tom lane

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

Предыдущее
От: Wayne Beaver
Дата:
Сообщение: Manual vacs 5x faster than autovacs?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Manual vacs 5x faster than autovacs?