| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce pgsql-hackers pgsql-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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-01-23 21:36:18 | Re: Much Ado About COUNT(*) |
| Previous Message | Bruce Momjian | 2005-01-22 21:19:16 | Re: Much Ado About COUNT(*) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hans-Jürgen Schönig | 2005-01-23 09:08:43 | Re: Two-phase commit for 8.1 |
| Previous Message | Anand Kumria | 2005-01-23 05:51:55 | Re: ARC patent |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-01-23 14:55:53 | Re: [PATCHES] 300 seconds in less than 1 second |
| Previous Message | Bruce Momjian | 2005-01-23 04:59:01 | Re: uptime function to postmaster |