Re: VACUUM ANALYZE differs under 7.2.3 from 7.2.1 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: VACUUM ANALYZE differs under 7.2.3 from 7.2.1
Date
Msg-id 15795.1035830951@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM ANALYZE differs under 7.2.3 from 7.2.1  (Jeff Boes <jboes@nexcerpt.com>)
List pgsql-bugs
Jeff Boes <jboes@nexcerpt.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

pgsql-bugs by date:

Previous
From: Michael Conn
Date:
Subject: Technical Question
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #806: create function failing... ERROR: stat failed on file '