Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres batch write very slow - what to do - Mailing list pgsql-performance

From Tom Lane
Subject Re: Postgres batch write very slow - what to do
Date
Msg-id 2950.1173801746@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres batch write very slow - what to do  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-performance
Tree view 
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> OP said he's using addBatch/executeBatch with a batch size of 100. The
> JDBC driver sends the whole batch before waiting for responses.

Perhaps a bit of checking with a packet sniffer would be warranted.
If it's really working like that he shouldn't see the network utilization
load he reported ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Postgres batch write very slow - what to do
Next
From: "Dengler, Michael"
Date:
Subject: Re: Autocommit in libpq