Re: [GENERAL] Benchmarks

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема Re: [GENERAL] Benchmarks
Дата
Msg-id Pine.BSF.4.21.0001061352500.18498-100000@thelab.hub.org
обсуждение исходный текст
Ответ на Re: [GENERAL] Benchmarks  (Dustin Sallings <dustin@spy.net>)
Ответы Re: [GENERAL] Benchmarks  (Dustin Sallings <dustin@spy.net>)
Список pgsql-general
On Thu, 6 Jan 2000, Dustin Sallings wrote:

>     Untrue, vacuum is *extremely* important for updating statistics.
> If you have a lot of data in a table, and you have never vacuumed, you
> might as well not have any indices.  It'd be nice if you could seperate
> the stat update from the storage reclaim.  Actually, it'd be nice if you
> could reuse storage, so that an actual vacuum wouldn't be necessary unless
> you just wanted to free up disk space you might end up using again anyway.

Okay, my understanding is that a vacuum does a 'cleanup', while a vacuum
analyze does a cleanup *and* stats...



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

Предыдущее
От: Dustin Sallings
Дата:
Сообщение: Re: [GENERAL] Benchmarks
Следующее
От: Dustin Sallings
Дата:
Сообщение: Re: [GENERAL] Benchmarks