Re: [GENERAL] more problems with count(*) on large table

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               
http://archives.postgresql.org/