OLAP idea
От
grant
Тема
OLAP idea
Дата
Msg-id
Pine.LNX.4.33.0205081518220.24032-100000@dbms.amadensor.com
Ответ на
Re: Contrib reindex script: (Shaun Thomas)
Список
Дерево обсуждения
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 по дате отправления