Re: Performance of count(*) - Mailing list pgsql-performance

From Brian Hurt
Subject Re: Performance of count(*)
Date
Msg-id 4602AA8B.3070505@janestcapital.com
Whole thread Raw
In response to Re: Performance of count(*)  ("Craig A. James" <cjames@modgraph-usa.com>)
Responses Re: Performance of count(*)  ("Craig A. James" <cjames@modgraph-usa.com>)
List pgsql-performance
Craig A. James wrote:

>
> One of our biggest single problems is this very thing.  It's not a
> Postgres problem specifically, but more embedded in the idea of a
> relational database: There are no "job status" or "rough estimate of
> results" or "give me part of the answer" features that are critical to
> many real applications.
>
For the "give me part of the answer", I'm wondering if cursors wouldn't
work (and if not, why not)?

Brian


pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Parallel Vacuum
Next
From: Mario Weilguni
Date:
Subject: Re: Performance of count(*)