Re: Question of using COPY on a table with triggers

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


> -----Original Message-----
> From: Pierre C [mailto:lists@peufeu.com]
> Sent: Thursday, July 15, 2010 4:47 PM
> To: Benjamin Krajmalnik; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Question of using COPY on a table with triggers
> 
> > Essentially, we insert a set of columns into a table, and each row
> fires
> > a trigger function which calls a very large stored procedure
> 
> 
> For inserting lots of rows, COPY is much faster than INSERT because it
> parses data (a lot) faster and is more "data-stream-friendly". However
> the
> actual inserting into the tbale and trigger-calling has to be done for
> both.
> 
> If the trigger is a "very large stored procedure" it is very likely
> that
> executing it will take a lot more time than parsing & executing the
> INSERT. So, using COPY instead of INSERT will not gain you anything.

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

Предыдущее
От: "Pierre C"
Дата:
Сообщение: Re: Question of using COPY on a table with triggers
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Identical query slower on 8.4 vs 8.3