From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jens Schipkowski <jens.schipkowski@apus.co.at>
Cc: pgsql-performance@postgresql.org
Subject: Re: really quick multiple inserts can use COPY?
Date: Mon, 11 Dec 2006 12:11:29 -0500
Message-ID: <13688.1165857089@sss.pgh.pa.us> (raw)
In-Reply-To: <op.tkekypo381rjf6@xjens.apus.local>
References: <op.tkekypo381rjf6@xjens.apus.local>
"Jens Schipkowski" <jens.schipkowski@apus.co.at> writes:
> Is it possible to use COPY FROM STDIN with JDBC?
You should be asking the pgsql-jdbc list, not here. (I know I've seen
mention of a JDBC patch to support COPY, but I dunno if it's made it into
any official version.)
> Will it bring performance improvement compared to SELECT UNION solution?
Please, at least be smart enough to use UNION ALL not UNION.
If you're using 8.2 you could also consider using INSERT with multiple
VALUES-lists.
regards, tom lane
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: tgl@sss.pgh.pa.us, jens.schipkowski@apus.co.at
Subject: Re: really quick multiple inserts can use COPY?
In-Reply-To: <13688.1165857089@sss.pgh.pa.us>
* 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