Re: Script and tool to monitoring sessions

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Script and tool to monitoring sessions
Дата
Msg-id mu1a51$eg0$1@ger.gmane.org
обсуждение исходный текст
Ответ на Re: Script and tool to monitoring sessions  (abdujaparov <afmulone@gmail.com>)
Список pgsql-novice
abdujaparov schrieb am 24.09.2015 um 18:27:
> We insert rows from a software that uses hibernate and there is only one
> final commit.
> The software execute one insert per row.
>
> Angelo
Ah, the mighty obfuscation layers.

You your problem is your application, not Postgres.

Not much you can do then, but you should at least check if batched inserts are enabled in Hibernate.

You alos might want to set "show_sql" to true, to verify that Hibernate isn't runnig
other statements as well that slow down the processing (e.g. a SELECT after each
INSERT or something similar stupid to obtain the generated sequence values)





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

Предыдущее
От: abdujaparov
Дата:
Сообщение: Re: Script and tool to monitoring sessions
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: Script and tool to monitoring sessions