Re: Still confused about VACUUM vs. VACUUM FULL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Still confused about VACUUM vs. VACUUM FULL
Дата
Msg-id 19837.1055440991@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Still confused about VACUUM vs. VACUUM FULL  (Jeff Boes <jboes@nexcerpt.com>)
Список pgsql-admin
Jeff Boes <jboes@nexcerpt.com> writes:
> On Thu, 2003-06-12 at 13:16, Tom Lane wrote:
>> That sounds a tad excessive; are the statistics really changing that
>> fast?

> Well, I have some convincing evidence on this.

Ah.  Well, you might consider analyzing just that table (maybe even just
its timestamp column) every few minutes, but I still doubt that it's
buying you much for most of the database.

            regards, tom lane

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

Предыдущее
От: Jeff Boes
Дата:
Сообщение: Re: Still confused about VACUUM vs. VACUUM FULL
Следующее
От: "Daniel Seichter"
Дата:
Сообщение: Run 4 postgresql session on ONE server?