Re: reltuples after vacuum and analyze

From: Litao Wu <litaowu(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: reltuples after vacuum and analyze
Date: 2005-01-25 18:48:08
Message-ID: 20050125184808.3866.qmail@web30309.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Believe or not.
The above command is my screen snapshot.

I believe it is most possibably a PG bug!

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Litao Wu <litaowu(at)yahoo(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2005-01-25 21:08:58 Re: PG versus FreeBSD, startup and connections problems
Previous Message Tom Lane 2005-01-25 18:43:51 Re: reltuples after vacuum and analyze