Issue with Save and Release points

From: <e(dot)ratnakar(dot)shetty(at)accenture(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: <daniel(dot)machet(at)accenture(dot)com>
Subject: Issue with Save and Release points
Date: 2016-06-16 16:21:24
Message-ID: 2469e362195c475898c777212b68b244@CO2PR4202MB0281.048d.mgd.msft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

We are using psqlodbc_09_05_0100-x86 driver to connect to Postgres 9.4 version through a VB app. When we try running continuous inserts from the application, the performance is really slow (18 minutes for upto a lakh records). On monitoring the logs, we found that there are huge number of save release point executions happening.

duration: 0.000 ms
2016-06-16 17:06:40 BST LOG: statement: RELEASE _EXEC_SVP_1B107E
2016-06-16 17:06:40 BST LOG: duration: 0.000 ms
2016-06-16 17:06:40 BST LOG: statement: SAVEPOINT _EXEC_SVP_1B1082F8
2016-06-16 17:06:40 BST LOG: duration: 0.000 ms

We tried switching this off by setting the "level of Rollback on error" to Nop and also through the connection string in the application but the logs still show these executions. Any pointers as to what might be causing this issue?

Many Thanks

Regards,
Eisha Shetty
ACCENTURE | UK-NEWCASTLE
* +44 7741587433
* e(dot)ratnakar(dot)shetty(at)accenture(dot)com<mailto:e(dot)ratnakar(dot)shetty(at)accenture(dot)com>
________________________________
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.Accenture means Accenture (UK) Limited (registered number 4757301), registered in England and Wales with registered address at 30 Fenchurch Street, London EC3M 3BD.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2016-06-17 01:41:01 Re: Issue with Save and Release points
Previous Message Michael Paquier 2016-06-16 12:51:53 Re: [PATCH] Remove unncessary localtime() calls during data type conversion