Postgres Pro
Downloads
Home   >   mailing lists

Re: really quick multiple inserts can use COPY? - Mailing list pgsql-performance

From Tom Lane
Subject Re: really quick multiple inserts can use COPY?
Date
Msg-id 13688.1165857089@sss.pgh.pa.us
Whole thread Raw
In response to really quick multiple inserts can use COPY?  ("Jens Schipkowski" <jens.schipkowski@apus.co.at>)
List pgsql-performance
Tree view 
"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

pgsql-performance by date:

Previous
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: really quick multiple inserts can use COPY?
Next
From: Guillaume Cottenceau
Date:
Subject: Re: really quick multiple inserts can use COPY?