Re: reltuples after vacuum and analyze

Поиск
Список
Период
Сортировка
От Litao Wu
Тема Re: reltuples after vacuum and analyze
Дата
Msg-id 20050125184808.3866.qmail@web30309.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: reltuples after vacuum and analyze  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Believe or not.
The above command is my screen snapshot.

I believe it is most possibably a PG bug!

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Litao Wu <litaowu@yahoo.com> writes:
> > reasonable size. But I do not understand
> > why "analyze" bloats the table size so
> > big??
>
> ANALYZE won't bloat anything.  I suppose you have
> other processes
> inserting or updating data in the table meanwhile.
>
>             regards, tom lane
>




__________________________________
Do you Yahoo!?
All your favorites on one personal page � Try My Yahoo!
http://my.yahoo.com

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

Предыдущее
От: Litao Wu
Дата:
Сообщение: Re: reltuples after vacuum and analyze
Следующее
От: Steve Poe
Дата:
Сообщение: Ideal disk setup for Postgresql 7.4?