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

From Simon Riggs
Subject Re: BUG #4276: Feature request aggregate indexes
Date
Msg-id 1215527047.4051.900.camel@ebony.2ndQuadrant
Whole thread Raw
In response to BUG #4276: Feature request aggregate indexes  ("x" <noreply@postgresql.org>)
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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #4286: ORDER BY returns inconsistent results when using LIMIT on a integer column set to default values
Next
From: Tom Lane
Date:
Subject: Re: BUG #4286: ORDER BY returns inconsistent results when using LIMIT on a integer column set to default values