Postgres Pro
Downloads
Home   >   mailing lists

Re: more problems with count(*) on large table - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: more problems with count(*) on large table
Date
Msg-id 20071001173353.GA20792@alvh.no-ip.org
Whole thread Raw
In response to Re: more problems with count(*) on large table  (Mike Charnoky <noky@nextbus.com>)
List pgsql-general
Tree view 
Mike Charnoky wrote:
> This is strange... count(*) operations over a period of one day's worth
> of data now take ~1-2 minutes to run or ~40 minutes.  It seems that the
> first time the data is queried it takes about 40 minutes.  If I try the
> query again, it finishes in 1-2 minutes!

This is just cache effect.



--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: using COPY, .CSV and ¿catalog?
Next
From: Bill Moran
Date:
Subject: Re: more problems with count(*) on large table