"Benjamin Krajmalnik" <kraj(at)servoyant(dot)com> writes:
> That is what I thought.
> The trigger calls a 3000 row stored procedure which does all of the calculations to aggregate data into 3 separate tables and then insert the raw data point into a 4th table.
Youch. Seems like you might want to rethink the idea of doing those
calculations incrementally for each added row. Wouldn't it be better
to add all the new data and then do the aggregation once?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2010-07-16 01:22:58|
|Subject: Re: performance on new linux box|
|Previous:||From: Benjamin Krajmalnik||Date: 2010-07-15 23:28:39|
|Subject: Re: Question of using COPY on a table with triggers|