| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Christopher Condit <condit(at)sdsc(dot)edu> |
| Cc: | Josh Rovero <rovero(at)sonalysts(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pgsql and streams |
| Date: | 2006-03-15 09:29:40 |
| Message-ID: | 4417DE84.9080501@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CSN | 2006-03-15 09:33:56 | Inserting in psql - invalid byte sequence for encoding "UNICODE": 0xe9 |
| Previous Message | Antonis Antoniou | 2006-03-15 09:17:05 | Re: out of memory |