Re: Question of using COPY on a table with triggers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Question of using COPY on a table with triggers
Дата
Msg-id 1005.1279239886@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Question of using COPY on a table with triggers  ("Benjamin Krajmalnik" <kraj@servoyant.com>)
Список pgsql-performance
"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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Identical query slower on 8.4 vs 8.3
Следующее
От: Ryan Wexler
Дата:
Сообщение: Re: performance on new linux box