In response to Mike Charnoky <noky@nextbus.com>:
> The autovacuum is turned on. Since this is pg8.1, I don't know when the
> table was actually last vacuumed. I *did* run analyze on the table,
> though. Also, nothing has been deleted in this table... so vacuum
> should have no affect, right?
Updated rows also produce dead tuples that require vacuuming. If the
table is insert only, you don't need vacuum.
--
Bill Moran
http://www.potentialtech.com
