Re: reltuples after vacuum and analyze - Mailing list pgsql-performance

From Litao Wu
Subject Re: reltuples after vacuum and analyze
Date
Msg-id 20050125184808.3866.qmail@web30309.mail.mud.yahoo.com
Whole thread Raw
In response to Re: reltuples after vacuum and analyze  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Litao Wu
Date:
Subject: Re: reltuples after vacuum and analyze
Next
From: Steve Poe
Date:
Subject: Ideal disk setup for Postgresql 7.4?