Re: Question of using COPY on a table with triggers

From: "Pierre C" <lists(at)peufeu(dot)com>
To: "Benjamin Krajmalnik" <kraj(at)servoyant(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Question of using COPY on a table with triggers
Date: 2010-07-15 22:46:54
Message-ID: op.vfwpkgx0eorkce@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pierre C 2010-07-15 22:57:28 Re: performance on new linux box
Previous Message Ben Chobot 2010-07-15 22:18:45 Re: performance on new linux box