| From: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | Arvind Sharma <arvind321(at)yahoo(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Triggers, Stored Procedures to Aggregate table ? |
| Date: | 2010-07-08 15:29:16 |
| Message-ID: | AANLkTim2VTbN_gMeo2qtRwHyOUCr-ihb_IjHgkwpA1DZ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, Jul 8, 2010 at 7:27 AM, Arvind Sharma <arvind321(at)yahoo(dot)com> wrote:
> Very new to the Triggers and Sprocs.
>
> I have few tables which stores raw data on minute basis. I want to aggregate
> this data into another table to store every hour worth of data. And from
> there on - from this hourly Aggregated table, want to store into another
> Aggregate Table for a day's worth of data.
>
> You got the direction I am going with this.. :-).... Hourly, Daily, Weekly
> aggregated data into their respective tables.
>
> Any pointers or suggestions or examples would be highly appreciated !
Here is a resource that describes various ways to create materialized views:
http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized_Views
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2010-07-08 17:08:12 | Re: Triggers, Stored Procedures to Aggregate table ? |
| Previous Message | Arvind Sharma | 2010-07-08 14:27:37 | Triggers, Stored Procedures to Aggregate table ? |