Idea for vacuuming

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Idea for vacuuming
Дата
Msg-id e7fble$2per$1@news.hub.org
обсуждение исходный текст
Ответы Re: Idea for vacuuming  (Jim Nasby <decibel@decibel.org>)
Список pgsql-general
I'm running a 8.0 database.  I have a very large log table that is
rarely updated or deleted from.  The nightly vacuum does not know this,
and spends a lot of time on it, and all its indexes.

My RFE: When vacuuming a table, pg should try to vacuum the primary key
first.  If that results in 0 recovered entries, then assume the table
has no updates/deletes and skip the rest of that table.  I'm picking the
primary key here, but any index that indexes each row of the table will
do.  Maybe it should just pick the smallest index that indexes each row
of the table.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: autovacuum template0
Следующее
От: "Florian G. Pflug"
Дата:
Сообщение: Re: aggregate of bitstrings