Re: **SPAM** Faster count(*)? - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: **SPAM** Faster count(*)?
Date
Msg-id 20050810105059.GA5448@phlogiston.dyndns.org
Whole thread Raw
In response to Re: **SPAM** Faster count(*)?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Tue, Aug 09, 2005 at 10:49:14PM -0400, Tom Lane wrote:
> 
> Current best practice is to run the explain and parse out the "rows"
> figure using a perl (or axe-of-choice) regexp, though we could be
> persuaded to supply a simpler API if there's enough demand for it.

FWIW, this was another one of those things I must have heard a dozen
times at OSCON.  I suspect the simpler API would be popular,
particularly since post-8.0 the estimates are more reliable than they
used to be.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.    --George Orwell


pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: **SPAM** Faster count(*)?
Next
From: Michael Fuhr
Date:
Subject: Re: **SPAM** Faster count(*)?