OLAP idea - Mailing list pgsql-general

From grant
Subject OLAP idea
Date
Msg-id Pine.LNX.4.33.0205081518220.24032-100000@dbms.amadensor.com
Whole thread Raw
In response to Re: Contrib reindex script:  (Shaun Thomas <sthomas@townnews.com>)
Responses Re: OLAP idea
Re: OLAP idea
List pgsql-general
I noticed that it is possible to build an index on a function to speed
retrieval of data.  The example in the docs was a create index on a name
field forced to lower case.  Would it be possible to make an index on an
aggregate to speed the return of aggregate info, while keeping it up to
date as the data changes?  I know that index maintenance would be HUGE
overhead, but on mostly static data that gets occasional updates, it could
be good.


pgsql-general by date:

Previous
From: Fran Fabrizio
Date:
Subject: Re: Contrib reindex script:
Next
From: Shaun Thomas
Date:
Subject: Contrib: Reindex script.