Re: Script and tool to monitoring sessions

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)