X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 9C5C353FC4
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue,  3 May 2005 11:42:41 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 41904-07
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue,  3 May 2005 14:42:37 +0000 (GMT)
Received: from mail.logix-tt.com (wallaby.dingens.org [212.75.36.180])
	by svr1.postgresql.org (Postfix) with ESMTP id 8EA1653FA0
	for <pgsql-performance@postgresql.org>;
	Tue,  3 May 2005 11:42:36 -0300 (ADT)
Received: from kingfisher.intern.logi-track.com (pD95DD5E9.dip0.t-ipconnect.de
	[217.93.213.233])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id C4AB5A861E;
	Tue,  3 May 2005 16:42:42 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logi-track.com (Postfix) with ESMTP id 7B471AB2D2;
	Tue,  3 May 2005 16:40:47 +0200 (CEST)
Message-ID: <42778D6E.4030401@logix-tt.com>
Date: Tue, 03 May 2005 16:40:46 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Debian Thunderbird 1.0.2 (X11/20050331)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: David Parker <dparker@tazznetworks.com>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>,
	tim@se.linux.org, pgsql-performance@postgresql.org
Subject: Re: batch inserts are "slow"
References: <07FDEE0ED7455A48AC42AC2070EDFF7C67EF1F@corpsrv2.tazznetworks.com>
In-Reply-To: 
 <07FDEE0ED7455A48AC42AC2070EDFF7C67EF1F@corpsrv2.tazznetworks.com>
X-Enigmail-Version: 0.91.0.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200505/12
X-Sequence-Number: 12176

Hi, all,

David Parker wrote:
> We ran into the need to use COPY, but our application is also in Java.
> We wrote a JNI bridge to a C++ routine that uses the libpq library to do
> the COPY. The coding is a little bit weird, but not too complicated -
> the biggest pain in the neck is probably getting it into your build
> system.

There are several hacks floating around that add COPY capabilities to
the pgjdbc driver. As they all are rather simple hacks, they have not
been included in the cvs yet, but they tend to work fine.

Markus