Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 28 Sep 2007 14:18:24 -0400
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
- Follow-Ups:
- Re: more problems with count(*) on large table
- From: Bill Moran
- Re: more problems with count(*) on large table
- References:
- more problems with count(*) on large table
- From: Mike Charnoky
- Re: more problems with count(*) on large table
- From: Sean Davis
- more problems with count(*) on large table
- Prev by Date: Re: more problems with count(*) on large table
- Next by Date: Re: more problems with count(*) on large table
- Previous by thread: Re: more problems with count(*) on large table
- Next by thread: Re: more problems with count(*) on large table
- Indexes: