Re: **SPAM** Faster count(*)?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: dracula007(at)atlas(dot)cz, pgsql-sql(at)postgresql(dot)org
Subject: Re: **SPAM** Faster count(*)?
Date: 2005-08-10 03:29:13
Message-ID: 20050810032913.GA40917@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2005-08-10 10:50:59 Re: **SPAM** Faster count(*)?
Previous Message tgh002 2005-08-10 03:03:47 insert into / select from / serial problem