Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 146F09F9F75 for ; Mon, 11 Dec 2006 13:11:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 98753-03 for ; Mon, 11 Dec 2006 13:11:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 2330B9F9F46 for ; Mon, 11 Dec 2006 13:11:40 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kBBHBTqY013689; Mon, 11 Dec 2006 12:11:29 -0500 (EST) To: "Jens Schipkowski" cc: pgsql-performance@postgresql.org Subject: Re: really quick multiple inserts can use COPY? In-reply-to: References: Comments: In-reply-to "Jens Schipkowski" message dated "Mon, 11 Dec 2006 17:19:27 +0100" Date: Mon, 11 Dec 2006 12:11:29 -0500 Message-ID: <13688.1165857089@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/245 X-Sequence-Number: 22301 "Jens Schipkowski" 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