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
