Jeff Boes <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
