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

From Michael Fuhr
Subject Re: **SPAM** Faster count(*)?
Date
Msg-id 20050810032913.GA40917@winnie.fuhr.org
Whole thread Raw
In response to Re: **SPAM** Faster count(*)?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: **SPAM** Faster count(*)?  (Michael Fuhr <mike@fuhr.org>)
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.

Somebody else requested a row-count-estimate function a couple of
weeks ago:

http://archives.postgresql.org/pgsql-admin/2005-07/msg00256.php

-- 
Michael Fuhr


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: **SPAM** Faster count(*)?
Next
From: Andrew Sullivan
Date:
Subject: Re: **SPAM** Faster count(*)?