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 25DC353482 for ; Tue, 3 May 2005 12:57:28 -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 54699-04 for ; Tue, 3 May 2005 15:57:23 +0000 (GMT) Received: from mail63.csoft.net (leary3.csoft.net [63.111.22.74]) by svr1.postgresql.org (Postfix) with SMTP id 2B8745374A for ; Tue, 3 May 2005 12:57:22 -0300 (ADT) Received: (qmail 15507 invoked by uid 1112); 3 May 2005 15:57:21 -0000 Date: Tue, 3 May 2005 10:57:21 -0500 (EST) From: Kris Jurka X-X-Sender: books@leary.csoft.net To: Josh Berkus Cc: Markus Schaber , David Parker , Christopher Kings-Lynne , tim@se.linux.org, pgsql-performance@postgresql.org Subject: Re: batch inserts are "slow" In-Reply-To: <200505030841.44159.josh@agliodbs.com> Message-ID: References: <07FDEE0ED7455A48AC42AC2070EDFF7C67EF1F@corpsrv2.tazznetworks.com> <42778D6E.4030401@logix-tt.com> <200505030841.44159.josh@agliodbs.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.011 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/16 X-Sequence-Number: 12180 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