Postgres Pro
Downloads
Home   >   mailing lists

Re: transparent use of pre-aggregated value for very large datasets - Mailing list pgsql-general

From Oleg Samoylov
Subject Re: transparent use of pre-aggregated value for very large datasets
Date
Msg-id b3vmih$1lg8$1@news.hub.org
Whole thread Raw
In response to transparent use of pre-aggregated value for very large datasets  (chaudhar@umich.edu (shahbaz))
List pgsql-general
Tree view 
In my project I encounter the same problem.

I use separate table for aggregated data per day and month. And use
triggers for update aggregated data when raw data inserted. It is
incorrect for relational database paradigm, but work fine for me.

--
Olleg Samoylov

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: triggers NOT showing up in phpPgAdmin
Next
From: cprice@hrdenterprises.com (Chris)
Date:
Subject: LIMIT and SUBQUERIES