Re: Postgres batch write very slow - what to do

От: Tom Lane
Тема: Re: Postgres batch write very slow - what to do
Дата: ,
Msg-id: 2950.1173801746@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Postgres batch write very slow - what to do  (Heikki Linnakangas)
Список: pgsql-performance

Скрыть дерево обсуждения

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 по дате сообщения:

От: Cosimo Streppone
Дата:
Сообщение: Re: PostgreSQL in virtual machine
От: "Anton Melser"
Дата:
Сообщение: Re: PostgreSQL 8.2.3 VACUUM Timings/Performance