Re: pgsql and streams

Christopher Condit wrote:
> Thanks for your response, Josh.  Actually I'm looking for the most
> general way to do this, since my remote database might not be psql.  In
> fact, I will probably be streaming through a java process.  So I'd like
> to go from the java process directly into the psql db.  Is it still
> possible?

I think recent JDBC drivers allow COPY, but you'll need to check the
documentation.

The other thing to do is to batch your inserts into groups of (say)
1000. That will provide a real speed increase.

--
   Richard Huxton
   Archonet Ltd