happened on a Sunday morning, my weekend
experiment to see how pg_autovacuum would maintain our test database was
rather spoiled ... 8-(
--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc.
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
