OLAP idea

Поиск
Список
Период
Сортировка
Искать
От
grant
Тема
OLAP idea
Дата
в 17:30:28
Msg-id
Pine.LNX.4.33.0205081518220.24032-100000@dbms.amadensor.com
Ответ на
Список
Дерево обсуждения
Contrib reindex script: Shaun Thomas <sthomas@townnews.com>
Re: Contrib reindex script: Bruce Momjian <pgman@candle.pha.pa.us>
Re: Contrib reindex script: "David Blood" <david@matraex.com>
Re: Contrib reindex script: Neil Conway <nconway@klamath.dyndns.org>
Re: Contrib reindex script: Bruce Momjian <pgman@candle.pha.pa.us>
Re: Contrib reindex script: Tom Lane <tgl@sss.pgh.pa.us>
Re: Contrib reindex script: Bruce Momjian <pgman@candle.pha.pa.us>
Re: Contrib reindex script: Tom Lane <tgl@sss.pgh.pa.us>
Re: Contrib reindex script: Bruce Momjian <pgman@candle.pha.pa.us>
Re: Contrib reindex script: Tom Lane <tgl@sss.pgh.pa.us>
Re: Contrib reindex script: Jason Earl <jason.earl@simplot.com>
Re: Contrib reindex script: Shaun Thomas <sthomas@townnews.com>
Re: Contrib reindex script: Bruce Momjian <pgman@candle.pha.pa.us>
Re: Contrib reindex script: Jason Earl <jason.earl@simplot.com>
OLAP idea grant <grant@amadensor.com>
Re: OLAP idea Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: OLAP idea "Nigel J. Andrews" <nandrews@investsystems.co.uk>
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.
FAQ