From: | "Adam Erickson" <adamre(at)cox(dot)net> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Aggregates and Indexes |
Date: | 2002-08-02 18:20:34 |
Message-ID: | ALEKKHACBIAEBNBPFKPCCEFHEDAA.adamre@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-sql |
Their has been some discussion regarding aggregate functions and indexes.
It's clear that aggregate functions will not take advantage of any indexes.
(ie. SELECT sum(number) FROM table WHERE type=BLAH will not take advantage
of 'type' being indexed.)
I do a lot of reporting based on such SQL statements. Counting rows from
large datasets. Since the PG gurus don't seem to think this is such a big
deal can someone enlighten me as to why?
Thanks,
Adam Erickson
From | Date | Subject | |
---|---|---|---|
Next Message | James Kelty | 2002-08-02 19:45:52 | Re: Replication |
Previous Message | 'knut.suebert@web.de' | 2002-08-02 17:59:51 | Re: delete other similar entries with timestamp <= times |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-08-02 18:24:12 | Re: Seeking advice regarding a design problem |
Previous Message | Oleg Bartunov | 2002-08-02 17:00:38 | Re: Ltree usage.. |