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: (view raw, whole thread or download thread mbox)
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)?


In response to


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-2017 The PostgreSQL Global Development Group