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 <heikki@enterprisedb.com>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Postgres batch write very slow - what to do
Следующее
От: "Dengler, Michael"
Дата:
Сообщение: Re: Autocommit in libpq