Re: CPU-intensive autovacuuming

Поиск
Список
Период
Сортировка
От Phil Endecott
Тема Re: CPU-intensive autovacuuming
Дата
Msg-id 42A5BEC3.4080409@chezphil.org
обсуждение исходный текст
Ответ на Re: CPU-intensive autovacuuming  ("Matthew T. O'Connor" <matthew@zeut.net>)
Ответы Re: CPU-intensive autovacuuming
Re: CPU-intensive autovacuuming
Re: CPU-intensive autovacuuming
Список pgsql-general
Matthew T. O'Connor wrote:
> The integrated version
> of autovacuum that didn't make the cut before 8.0 avoids this problem
> since the autovacuum data is stored in the database.

What is the status of this?  Is it something that will be included in
8.1 or 8.0.n?  I might be able to patch the current code but that
doesn't seem like a useful thing to do if a better solution will arrive
eventually.  I am currently running vacuums from a cron job and I think
I will be happy with that for the time being.

(Incidentally, I have also found that the indexes on my pg_attributes
table were taking up over half a gigabyte, which came down to less than
40 megs after reindexing them.  Is there a case for having autovacuum
also call reindex?)

--Phil.


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