Re: Performance of count(*)

From: Brian Hurt <bhurt(at)janestcapital(dot)com>
To: "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance of count(*)
Date: 2007-03-22 16:10:51
Message-ID: 4602AA8B.3070505@janestcapital.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mario Weilguni 2007-03-22 16:20:02 Re: Performance of count(*)
Previous Message Alvaro Herrera 2007-03-22 16:09:19 Re: Parallel Vacuum