Horton

Re: Inserting heap tuples in bulk in COPY

Gurjeet Singh <singh.gurjeet@gmail.com>

View thread
From: Gurjeet Singh <singh.gurjeet@gmail.com>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-08-12T19:44:47Z
Lists: pgsql-hackers 
On Fri, Aug 12, 2011 at 3:16 PM, Heikki Linnakangas <
heikki.linnakangas@enterprisedb.com> wrote:

> COPY is slow.


No kidding!


> So at least for now, the patch simply falls back to inserting one row at a
> time if there are any triggers on the table.
>

Maybe we want to change that to "fall back to old ways if there are any FOR
EACH ROW triggers", since FOR EACH STATEMENT triggers won't be bothered by
this optimization.

-- 
Gurjeet Singh
EnterpriseDB Corporation
The Enterprise PostgreSQL Company