Re: VACUUM and ANALYZE Follow-Up

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: VACUUM and ANALYZE Follow-Up
Дата
Msg-id 41AB81BC.5090409@commandprompt.com
обсуждение исходный текст
Ответ на VACUUM and ANALYZE Follow-Up  ("Mark Dexter" <MDEXTER@dexterchaney.com>)
Ответы Re: VACUUM and ANALYZE Follow-Up  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re: VACUUM and ANALYZE Follow-Up  (Mage <mage@mage.hu>)
Список pgsql-general
>
> In any case, it is hard to see how the present behaviour can be seen as
> desirable.  It obviously causes problems at least for new Postgres
> users, and we
> all hope there will be many more of these folks in the future.  Thanks
> for considering this.  Mark

Uhmmm... analyze or vacuum on an empty table is fairly pointless. Those
utilities are supposed to be used on tables that have data.

So the answer is, use them on tables that have data.

Sincerely,

Joshua D. Drake



>


--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Вложения

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

Предыдущее
От: "Mark Dexter"
Дата:
Сообщение: VACUUM and ANALYZE Follow-Up
Следующее
От: Tom Lane
Дата:
Сообщение: Re: VACUUM and ANALYZE Follow-Up