Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group