Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group