Re: [PERFORM] Trigger or Function

2011-08-02 Thread Gavin Flower
On 01/08/11 19:18, Robert Klemme wrote: On Sat, Jul 30, 2011 at 3:01 AM, Gavin Flower wrote: On 24/07/11 03:58, alan wrote: My first approach would be to remove WeekAvg and MonthAvg from the table and create a view which calculates appropriate values. Thanks Robert, I had to upgrade to 9.0.4

Re: [PERFORM] Trigger or Function

2011-08-01 Thread Robert Klemme
On Sat, Jul 30, 2011 at 3:01 AM, Gavin Flower wrote: > On 24/07/11 03:58, alan wrote: >>> >>> My first approach would be to remove WeekAvg and MonthAvg from the >>> table and create a view which calculates appropriate values. >> >> Thanks Robert, I had to upgrade to 9.0.4 to use the extended windo

Re: [PERFORM] Trigger or Function

2011-07-31 Thread Gavin Flower
On 24/07/11 03:58, alan wrote: My first approach would be to remove WeekAvg and MonthAvg from the table and create a view which calculates appropriate values. Thanks Robert, I had to upgrade to 9.0.4 to use the extended windowing features. Here is how I set it up. If anyone sees an issue, please

Re: [PERFORM] Trigger or Function

2011-07-29 Thread alan
> My first approach would be to remove WeekAvg and MonthAvg from the > table and create a view which calculates appropriate values. Thanks Robert, I had to upgrade to 9.0.4 to use the extended windowing features. Here is how I set it up. If anyone sees an issue, please let me know. I'm new to post

Re: [PERFORM] Trigger or Function

2011-07-14 Thread Robert Klemme
On Tue, Jul 12, 2011 at 9:41 AM, alan wrote: > Hello, > I'm a postgres newbie and am wondering what's the best way to do this. > > I am gathering some data and will be inserting to a table once daily. > The table is quite simple but I want the updates to be as efficient as > possible since > this