Re: transparent use of pre-aggregated value for very large datasets

From: Oleg Samoylov <olleg(at)telecom(dot)mipt(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: transparent use of pre-aggregated value for very large datasets
Date: 2003-03-03 13:50:10
Message-ID: b3vmih$1lg8$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rod Taylor 2003-03-03 13:59:34 Re: Off topic - was Re: ALTER SEQUENCE
Previous Message Shridhar Daithankar<shridhar_daithankar@persistent.co.in> 2003-03-03 13:43:02 Re: wal-debug