From: Dave Cramer <pg@fastcrypt.com>
To: Kris Jurka <books@ejurka.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Markus Schaber <schabi@logix-tt.com>
Cc: David Parker <dparker@tazznetworks.com>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: tim@se.linux.org
Cc: pgsql-performance@postgresql.org
Subject: Re: batch inserts are "slow"
Date: Tue, 03 May 2005 15:58:59 -0400
Message-ID: <4277D803.6060902@fastcrypt.com> (raw)
In-Reply-To: <Pine.BSO.4.56.0505031055050.6572@leary.csoft.net>
References: <07FDEE0ED7455A48AC42AC2070EDFF7C67EF1F@corpsrv2.tazznetworks.com>
<42778D6E.4030401@logix-tt.com>
<200505030841.44159.josh@agliodbs.com>
<Pine.BSO.4.56.0505031055050.6572@leary.csoft.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pg@fastcrypt.com, books@ejurka.com, josh@agliodbs.com, schabi@logix-tt.com, dparker@tazznetworks.com, chriskl@familyhealth.com.au, tim@se.linux.org
Subject: Re: batch inserts are "slow"
In-Reply-To: <4277D803.6060902@fastcrypt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox