Skip site navigation (1) Skip section navigation (2)

Aggregates ?? Datamart (to whatever it has implemented a DataMart using Postgres)

From: "Esteban Kemp" <ekemp(at)inf(dot)uach(dot)cl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Aggregates ?? Datamart (to whatever it has implemented a DataMart using Postgres)
Date: 2004-09-27 23:04:50
Message-ID: 001101c4a4e6$649c6160$96d85392@tesisek (view raw or flat)
Thread:
Lists: pgsql-general
This is the Problem:

  I'm building a Large DataMart with a big table and I want to improve the performace using aggregates I mean a set of table that store some specific aggregacion of the main table, like materialized views, I know that this feature is not implemented yet in postgres, And I see a interesting article to implementing this using a set of triggers, but I thing the big problem is not the rate of the updates or the real time consistence between both table, the main and the agregates. I thing the really problem is how to let it know to the RDMS engine that this aggregates exist!, I mean when I run a query I want to the Database engine run the query against the correct table.

I thing if some day postgres allow to do this, will could use postgres more confortablement in Data warehouse proyect.

I read today the TODO list of postgres and I don't see anithing like this...
Any alternative??

or how you solve the problem of the agregates in yours DataMarts???


any commentari is well recived



Responses

pgsql-general by date

Next:From: Marc G. FournierDate: 2004-09-27 23:29:25
Subject: PostgreSQL 8.0.0 Beta 3 Uploaded
Previous:From: John LiuDate: 2004-09-27 21:18:41
Subject: Re: core dump on select

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group