Postgres Pro
Downloads
Home   >   mailing lists

Re: constant time count(*) ? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: constant time count(*) ?
Date
Msg-id Pine.LNX.4.44.0310152025050.21950-100000@peter.localdomain
Whole thread Raw
In response to constant time count(*) ?  (Mark Harrison <mh@pixar.com>)
List pgsql-general
Tree view 
Mark Harrison writes:

> Is there a way to optimize count(*) such that it does not have
> to do a sequential scan?

No.  If you need to count a lot, you need to store the information
separately.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Getting error codes for failed queries?
Next
From: "Dann Corbit"
Date:
Subject: Re: constant time count(*) ?