Re: Postgres batch write very slow - what to do

From: Tom Lane
Subject: Re: Postgres batch write very slow - what to do
Date: ,
Msg-id: 2950.1173801746@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: Postgres batch write very slow - what to do  (Heikki Linnakangas)
List: pgsql-performance

Tree view

Postgres batch write very slow - what to do  (femski, )
 Re: Postgres batch write very slow - what to do  (Heikki Linnakangas, )
  Re: Postgres batch write very slow - what to do  (femski, )
   Re: Postgres batch write very slow - what to do  (Tom Lane, )
    Re: Postgres batch write very slow - what to do  (Heikki Linnakangas, )
     Re: Postgres batch write very slow - what to do  (Tom Lane, )
   Re: Postgres batch write very slow - what to do  (femski, )
    Re: Postgres batch write very slow - what to do  ("Merlin Moncure", )
     Re: Postgres batch write very slow - what to do  (femski, )
      Re: Postgres batch write very slow - what to do  ("Merlin Moncure", )
       Re: Postgres batch write very slow - what to do  (femski, )
        Re: Postgres batch write very slow - what to do  (Tom Lane, )
        Re: Postgres batch write very slow - what to do  ("Merlin Moncure", )
         Re: Postgres batch write very slow - what to do  ("Merlin Moncure", )
 Re: Postgres batch write very slow - what to do  ("Merlin Moncure", )
 Re: Postgres batch write very slow - what to do  ("Merlin Moncure", )
 Re: Postgres batch write very slow - what to do  ("Joshua D. Drake", )
  Re: Postgres batch write very slow - what to do  (Carlos Moreno, )
   Re: Postgres batch write very slow - what to do  ("Joshua D. Drake", )
 Re: Postgres batch write very slow - what to do  ("hubert depesz lubaczewski", )

Heikki Linnakangas <> 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:

From: Cosimo Streppone
Date:
Subject: Re: PostgreSQL in virtual machine
From: "Anton Melser"
Date:
Subject: Re: PostgreSQL 8.2.3 VACUUM Timings/Performance