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

From: Mike Charnoky <noky(at)nextbus.com>
Date: Fri Sep 28 2007 - 14:18:24 EDT

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?

Mike

Sean Davis wrote:
> Mike Charnoky wrote:

>> Hi,
>>
>> I am still having problems performing a count(*) on a large table.

> Have you vacuumed recently?
>
> Sean

---------------------------(end of broadcast)---------------------------

TIP 5: don't forget to increase your free space map settings Received on Fri Sep 28 14:21:46 2007