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

Re: Much Ado About COUNT(*)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jonah H(dot) Harris" <jharris(at)tvi(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Much Ado About COUNT(*)
Date: 2005-01-12 18:24:26
Message-ID: 29927.1105554266@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-hackerspgsql-patches
"Jonah H. Harris" <jharris(at)tvi(dot)edu> writes:
> Tom, Bruce, and others involved in this recurring TODO discussion
> First, let me start by saying that I understand this has been discussed 
> many times before; however, Id like to see what the current state of 
> affairs is regarding the possibility of using a unique index scan to 
> speed up the COUNT aggregate.

It's not happening, because no one has come up with a workable proposal.
In particular, we're not willing to slow down every other operation in
order to make COUNT-*-with-no-WHERE-clause faster.

			regards, tom lane

In response to

Responses

pgsql-announce by date

Next:From: Reinhard MaxDate: 2005-01-12 18:36:52
Subject: segfault caused by heimdal (was: SUSE port)
Previous:From: Jonah H. HarrisDate: 2005-01-12 17:42:56
Subject: Much Ado About COUNT(*)

pgsql-hackers by date

Next:From: Reinhard MaxDate: 2005-01-12 18:36:52
Subject: segfault caused by heimdal (was: SUSE port)
Previous:From: Jonah H. HarrisDate: 2005-01-12 17:42:56
Subject: Much Ado About COUNT(*)

pgsql-patches by date

Next:From: Reinhard MaxDate: 2005-01-12 18:36:52
Subject: segfault caused by heimdal (was: SUSE port)
Previous:From: Jonah H. HarrisDate: 2005-01-12 17:42:56
Subject: Much Ado About COUNT(*)

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