"Benjamin Krajmalnik" <kraj@xxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
