| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | grant <grant(at)amadensor(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: OLAP idea |
| Date: | 2002-05-08 23:11:46 |
| Message-ID: | Pine.LNX.4.21.0205090011150.2371-100000@ponder.fairway2k.co.uk |
| 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.
No, it isn't possible to create an index on a function.
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Barwick | 2002-05-08 23:13:22 | Re: having trouble w/ having clause... |
| Previous Message | grant | 2002-05-08 22:21:14 | OLAP idea |