Re: [JDBC] number of transactions doubling

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: [JDBC] number of transactions doubling
Дата
Msg-id 451C4B9C.9060108@opencloud.com
обсуждение исходный текст
Ответ на number of transactions doubling  ("Sriram Dandapani" <sdandapani@counterpane.com>)
Список pgsql-admin
Sriram Dandapani wrote:

> The target table has triggers that route data to appropriate tables. The
> tables to which data is routed has check constraints that do further
> inserts. (All of this happens in 1 jdbc transaction)
>
> I expect  JDBC Batching to generate fewer transactions depending on
> batch size.

Have you turned autocommit off?

-O

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Paul B. Anderson"
Дата:
Сообщение: Addendum on stored procedure array limits
Следующее
От: "Sriram Dandapani"
Дата:
Сообщение: Re: [JDBC] number of transactions doubling