Re: Script and tool to monitoring sessions

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Script and tool to monitoring sessions
Date: 2015-09-24 16:59:08
Message-ID: mu1a51$eg0$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sergey Konoplev 2015-09-25 04:00:42 Re: Script and tool to monitoring sessions
Previous Message abdujaparov 2015-09-24 16:35:57 Re: Script and tool to monitoring sessions