| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | grant <grant(at)amadensor(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: OLAP idea |
| Date: | 2002-05-09 02:01:50 |
| Message-ID: | 20020508185337.R6037-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 8 May 2002, grant wrote:
> 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.
You can't currently do that with a functional index, but you should be
able to do that via triggers.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2002-05-09 04:24:52 | Re: Performance issues with compaq server |
| Previous Message | Jeff Lu | 2002-05-08 23:53:24 | What are the procedures for upgrading from 7.1.2 to 7.2 |