Aggregates and Indexes

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

In response to

Responses

Browse pgsql-novice by date

  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

Browse pgsql-sql by date

  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..