Re: [BUGS] VACUUM ANALYZE differs under 7.2.3 from 7.2.1

2002-10-28 Thread Tom Lane
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

[BUGS] VACUUM ANALYZE differs under 7.2.3 from 7.2.1

2002-10-28 Thread Jeff Boes
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. Here is a sequence of SQL commands to demonstrate the difference. Under 7.2.1, the result