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

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

From
"Esteban Kemp"
Date:
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
 
 
 
 
On Mon, Sep 27, 2004 at 07:04:50PM -0400, Esteban Kemp wrote:

Esteban,

>   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 think you may be interested in reading "Materialized Views in
PostgreSQL" by Jonathan Gardner.

http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html


You may also want to subscribe to the pgsql-es-ayuda, at
http://archives.postgresql.org/pgsql-es-ayuda.  We can discuss further
there without the language barrier ...

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Este mail se entrega garantizadamente 100% libre de sarcasmo.