OLAP idea

From: grant <grant(at)amadensor(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: OLAP idea
Date: 2002-05-08 22:21:14
Message-ID: Pine.LNX.4.33.0205081518220.24032-100000@dbms.amadensor.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2002-05-08 23:11:46 Re: OLAP idea
Previous Message Shaun Thomas 2002-05-08 21:52:15 Contrib: Reindex script.