Re: Question of using COPY on a table with triggers - Mailing list pgsql-performance

From Pierre C
Subject Re: Question of using COPY on a table with triggers
Date
Msg-id op.vfwpkgx0eorkce@apollo13
Whole thread Raw
In response to Question of using COPY on a table with triggers  ("Benjamin Krajmalnik" <kraj@servoyant.com>)
Responses Re: Question of using COPY on a table with triggers
List pgsql-performance
> 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 by date:

Previous
From: Ben Chobot
Date:
Subject: Re: performance on new linux box
Next
From: "Benjamin Krajmalnik"
Date:
Subject: Re: Question of using COPY on a table with triggers