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

From: Mike Charnoky <noky(at)nextbus(dot)com>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: more problems with count(*) on large table
Date: 2007-09-28 18:18:24
Message-ID: 46FD4570.1080705@nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-09-28 18:44:35 Re: more problems with count(*) on large table
Previous Message Sean Davis 2007-09-28 18:11:13 Re: more problems with count(*) on large table