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

Re: Much Ado About COUNT(*)

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: Much Ado About COUNT(*)
Date: 2005-01-23 08:36:10
Message-ID: 41F361FA.4080908@cheapcomplexdevices.com (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-hackerspgsql-patches
Bruce Momjian wrote:
> Added to TODO based on this discusion:... 
> * Speed up COUNT(*)

One think I think would help lots of people is if the
documentation near the COUNT aggregate explained some
of the techniques using triggers to maintain a count
for tables where this is important.

For every one person who reads the mailinglist archives,
I bet there are dozens who merely read the product
documentation and never find the workaround/solution.

Perhaps a note below the table here:
http://www.postgresql.org/docs/8.0/interactive/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
would be a good place.   If it is already somewhere in
the docs; perhaps the page I linked should refer to the
other page as well.

In response to

Responses

pgsql-announce by date

Next:From: Jim C. NasbyDate: 2005-01-23 21:36:18
Subject: Re: Much Ado About COUNT(*)
Previous:From: Bruce MomjianDate: 2005-01-22 21:19:16
Subject: Re: Much Ado About COUNT(*)

pgsql-hackers by date

Next:From: Hans-Jürgen SchönigDate: 2005-01-23 09:08:43
Subject: Re: Two-phase commit for 8.1
Previous:From: Anand KumriaDate: 2005-01-23 05:51:55
Subject: Re: ARC patent

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-01-23 14:55:53
Subject: Re: [PATCHES] 300 seconds in less than 1 second
Previous:From: Bruce MomjianDate: 2005-01-23 04:59:01
Subject: Re: uptime function to postmaster

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