OLAP idea

Поиск
Список
Период
Сортировка
От grant
Тема OLAP idea
Дата
Msg-id Pine.LNX.4.33.0205081518220.24032-100000@dbms.amadensor.com
обсуждение исходный текст
Ответ на Re: Contrib reindex script:  (Shaun Thomas <sthomas@townnews.com>)
Ответы Re: OLAP idea  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Re: OLAP idea  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Fran Fabrizio
Дата:
Сообщение: Re: Contrib reindex script:
Следующее
От: Shaun Thomas
Дата:
Сообщение: Contrib: Reindex script.