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 02981538AA for ; Tue, 3 May 2005 16:59:14 -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 08345-08 for ; Tue, 3 May 2005 19:59:04 +0000 (GMT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id E870153547 for ; Tue, 3 May 2005 16:59:02 -0300 (ADT) Received: (qmail 12896 invoked from network); 3 May 2005 19:57:36 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.36?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 3 May 2005 19:57:36 -0000 Message-ID: <4277D803.6060902@fastcrypt.com> Date: Tue, 03 May 2005 15:58:59 -0400 From: Dave Cramer Reply-To: pg@fastcrypt.com Organization: Postgres International User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kris Jurka Cc: Josh Berkus , Markus Schaber , David Parker , Christopher Kings-Lynne , tim@se.linux.org, pgsql-performance@postgresql.org Subject: Re: batch inserts are "slow" References: <07FDEE0ED7455A48AC42AC2070EDFF7C67EF1F@corpsrv2.tazznetworks.com> <42778D6E.4030401@logix-tt.com> <200505030841.44159.josh@agliodbs.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.026 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/26 X-Sequence-Number: 12190 Kris is correct, This code was not added or even submitted to CVS. The purpose of this was to work out the bugs with people who are actually using copy. The api is a separate issue however. There's no reason that copy can't support more than one api. Dave Kris Jurka wrote: >On Tue, 3 May 2005, Josh Berkus wrote: > > > >>>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. >>> >>> >>FWIW, Dave Cramer just added beta COPY capability to JDBC. Contact him on >>the JDBC list for details; I think he needs testers. >> >> >> > >I believe Dave has remerged a patch for COPY I posted over a year ago, but >he has not yet published it. I would guess it has the same bugs as the >original (transaction + error handling) and will meet the same objections >that kept the original patch out of the driver in the first place (we want >a friendlier API than just a data stream). > >Kris Jurka > >---------------------------(end of broadcast)--------------------------- >TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > > > > -- Dave Cramer http://www.postgresintl.com 519 939 0336 ICQ#14675561