"Benjamin Krajmalnik" <kraj@servoyant.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
tablesand 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
