Re: batch inserts are "slow"

From: Kris Jurka <books(at)ejurka(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Markus Schaber <schabi(at)logix-tt(dot)com>, David Parker <dparker(at)tazznetworks(dot)com>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, tim(at)se(dot)linux(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: batch inserts are "slow"
Date: 2005-05-03 15:57:21
Message-ID: Pine.BSO.4.56.0505031055050.6572@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-05-03 15:59:47 Re: Foreign key constraints compile faster in 7.4
Previous Message Steven Rosenstein 2005-05-03 15:55:15