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

Re: Much Ado About COUNT(*)

From: "Jonah H(dot) Harris" <jharris(at)tvi(dot)edu>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Much Ado About COUNT(*)
Date: 2005-01-12 21:48:33
Message-ID: 41E59B31.2090803@tvi.edu (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-hackerspgsql-patches
Bruno Wolff III wrote:

>On Wed, Jan 12, 2005 at 14:09:07 -0700,
>  "Jonah H. Harris" <jharris(at)tvi(dot)edu> wrote:
>
>Please keep stuff posted to the list so that other people can contribute
>and learn from the discussion unless there is a particular reason to
>limited who is involved in the discussion.
>
>  
>
not a problem.

>Perhaps you think that the count is somehow saved in the index so that
>you don't have to scan through the whole index to get the number of
>rows in a table? That isn't the case, but is what creating a materialized
>view would effectively do for you.
>  
>
I understand that the count is not stored in the index.  I am saying 
that it may be faster to generate the count off the keys in the index.

I shouldn't have titled this message COUNT(*) as that isn't the only 
thing I'm trying to accomplish.

In response to

pgsql-announce by date

Next:From: Bruno Wolff IIIDate: 2005-01-12 21:56:25
Subject: Re: Much Ado About COUNT(*)
Previous:From: Simon RiggsDate: 2005-01-12 21:45:51
Subject: Re: Much Ado About COUNT(*)

pgsql-hackers by date

Next:From: Bruno Wolff IIIDate: 2005-01-12 21:56:25
Subject: Re: Much Ado About COUNT(*)
Previous:From: Simon RiggsDate: 2005-01-12 21:45:51
Subject: Re: Much Ado About COUNT(*)

pgsql-patches by date

Next:From: Bruno Wolff IIIDate: 2005-01-12 21:56:25
Subject: Re: Much Ado About COUNT(*)
Previous:From: Simon RiggsDate: 2005-01-12 21:45:51
Subject: Re: Much Ado About COUNT(*)

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