Re: Script and tool to monitoring sessions - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: Script and tool to monitoring sessions
Date
Msg-id mu1a51$eg0$1@ger.gmane.org
Whole thread Raw
In response to Re: Script and tool to monitoring sessions  (abdujaparov <afmulone@gmail.com>)
List 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 by date:

Previous
From: abdujaparov
Date:
Subject: Re: Script and tool to monitoring sessions
Next
From: Sergey Konoplev
Date:
Subject: Re: Script and tool to monitoring sessions