| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | femski <hypertree(at)yahoo(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgres batch write very slow - what to do |
| Date: | 2007-03-13 15:56:11 |
| Message-ID: | 45F6C99B.1080507@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Tom Lane wrote:
> It sounds like you're incurring a network round trip for each row, which
> will be expensive even for a co-located application. Perhaps Oracle's
> JDBC driver is smart enough to avoid that. I'm not sure what tricks are
> available for bulk loading with our JDBC driver --- the page Heikki
> mentioned explains things from a server perspective but I dunno how that
> translates into JDBC. The folks who hang out on pgsql-jdbc could
> probably give you some tips.
OP said he's using addBatch/executeBatch with a batch size of 100. The
JDBC driver sends the whole batch before waiting for responses.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-13 16:02:26 | Re: Postgres batch write very slow - what to do |
| Previous Message | vincent.moreau | 2007-03-13 15:46:34 | Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3 |