Re: Fastest method to insert data.

On Fri, Apr 19, 2002 at 12:49:38PM -0700, Barry Lind wrote:

> COPY will always be your best option if speed is the most important factor.

Would COPY issued through JDBC actually work?  My understanding is that for
non-postgres uid clients the COPY command is restricted to using stdin/stdout
only.  Or perhaps it's an artificial limitation imposed by psql.  I don't think
I've seen a COPY TABLE JDBC extension in the documentation.

Resetting System.cin/System.cout to a file, then issuing a COPY TABLE might
be worth investigating, but that's a hack.

>
> --Barry
>
> Sam Varshavchik wrote:
> >
> > What would be the fastest way to insert a bunch of data (in 7.1)?
> > Currently, a bunch of addBatch()es followed by executeBatch() is pretty
> > fast, but not as fast as COPY TABLE via psql.  I suppose I can use a
> > single executeBatch() to insert the entire table, but AFAIK addBatch()
> > just buffers the SQL in memory, and I prefer to have some kind of an
> > upper limit on my memory footprint.
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
Sam