Re: VACUUM ANALYZE differs under 7.2.3 from 7.2.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Boes <jboes(at)nexcerpt(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: VACUUM ANALYZE differs under 7.2.3 from 7.2.1
Date: 2002-10-28 18:49:11
Message-ID: 15795.1035830951@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jeff Boes <jboes(at)nexcerpt(dot)com> writes:
> The "VACUUM ANALYZE tablename" command does not have the same effect on
> table metadata under 7.2.1 and 7.2.3. In particular, I've noted that
> pg_class.reltuples is not updated by vacuuming after a delete.

Hard to believe ... I see no changes in the 7.2.* CVS logs that might
cause such a problem.

> Here is a sequence of SQL commands to demonstrate the difference. Under
> 7.2.1, the resulting last three displays of the pg_class.reltuples value
> will be zero (0), while under 7.2.3 it will be 10.

Here I get zeroes, as you expect, with 7.2.3. Some problem with your
installation perhaps?

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-10-28 23:44:09 Bug #806: create function failing... ERROR: stat failed on file '
Previous Message Mr Yves Crevecoeur 2002-10-28 17:39:55 Re: socket problem under BeOS