Re: BUG #4276: Feature request aggregate indexes - Mailing list pgsql-bugs

On Tue, 2008-07-01 at 13:27 +0000, x wrote:
> The following bug has been logged online:
>
> Bug reference:      4276
> Logged by:          x
> Email address:      noreply@postgresql.org
> PostgreSQL version: n/a
> Operating system:   n/a
> Description:        Feature request aggregate indexes
> Details:
>
> # CREATE INDEX count_star ON fscrbank (COUNT(*));
> ERROR:  cannot use aggregate function in index expression
>
> Don't know how the architechture would handle it but this should be
> possible.

The developers agree this is a good idea. It is already on the TODO,
described as "materialized views", though I like your name for it also,
since that is the main use case.
http://www.postgresql.org/docs/faqs.TODO.html

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support