Received-SPF: Pass (protection.outlook.com: domain of accenture.com designates
 170.252.43.201 as permitted sender) receiver=protection.outlook.com;
 client-ip=170.252.43.201; helo=AMRXE4006.accenture.com;
From: <e.ratnakar.shetty@accenture.com>
To: <pgsql-performance@postgresql.org>
CC: <daniel.machet@accenture.com>
Subject: Savepoint and Releasepoint in Logs
Thread-Topic: Savepoint and Releasepoint in Logs
Thread-Index: AdHIqxgq64uDcoorR0mwCCIap9tQqg==
Date: Fri, 17 Jun 2016 15:19:34 +0000
Message-ID: 
 <632c061e261d478699e48af2a24363a7@CO2PR4202MB0281.048d.mgd.msft.net>
Accept-Language: en-US
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_632c061e261d478699e48af2a24363a7CO2PR4202MB0281048dmgdm_"
MIME-Version: 1.0
SpamDiagnosticOutput: 1:99
SpamDiagnosticMetadata: NSPM
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 17 Jun 2016 15:20:08.4857
 (UTC)
X-MS-Exchange-CrossTenant-Id: e0793d39-0939-496d-b129-198edd916feb
X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: 
 TenantId=e0793d39-0939-496d-b129-198edd916feb;Ip=[170.252.43.201];Helo=[AMRXE4006.accenture.com]
X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1P114MB0062
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--_000_632c061e261d478699e48af2a24363a7CO2PR4202MB0281048dmgdm_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi ,

I am connecting to PostgreSQL 9.4 via an ODBC driver on Windows machine fro=
m MS VBA application. I am facing huge performance issues while inserting d=
ata continuously. On analysing the logs , there were around 90000 statement=
s related to Save Points and Release Points.

duration: 2.000 ms
2016-06-17 12:45:02 BST LOG:  statement: RELEASE _EXEC_SVP_1018CCF8
2016-06-17 12:45:02 BST LOG:  duration: 1.000 ms
2016-06-17 12:45:05 BST LOG:  statement: SAVEPOINT _EXEC_SVP_186EB5C8
2016-06-17 12:45:05 BST LOG:  duration: 0.000 ms

I am guessing these statements are causing an overhead while inserting reco=
rds in to the table. Could you please let me know if I need to change any c=
onfiguration settings to avoid creating any save points as the transaction =
is handled in the application.

Thanks

Regards,
Eisha Shetty
ACCENTURE | UK-NEWCASTLE
* +44 7741587433
* e.ratnakar.shetty@accenture.com<mailto:e.ratnakar.shetty@accenture.com>
________________________________
This message is for the designated recipient only and may contain privilege=
d, proprietary, or otherwise private information. If you have received it i=
n 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, e=
lectronic communications with Accenture and its affiliates, including e-mai=
l and instant messaging (including content), may be scanned by our systems =
for the purposes of information security and assessment of internal complia=
nce with Accenture policy.Accenture means Accenture (UK) Limited (registere=
d number 4757301), registered in England and Wales with registered address =
at 30 Fenchurch Street, London EC3M 3BD.


--_000_632c061e261d478699e48af2a24363a7CO2PR4202MB0281048dmgdm_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
	{font-family:Wingdings;
	panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-GB" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi ,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I am connecting to PostgreSQL 9.4 via an ODBC driver=
 on Windows machine from MS VBA application. I am facing huge performance i=
ssues while inserting data continuously. On analysing the logs , there were=
 around 90000 statements related to
 Save Points and Release Points. <o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">duration: 2.000 ms<o:p></o:p></p>
<p class=3D"MsoNormal">2016-06-17 12:45:02 BST LOG:&nbsp; statement: RELEAS=
E _EXEC_SVP_1018CCF8<o:p></o:p></p>
<p class=3D"MsoNormal">2016-06-17 12:45:02 BST LOG:&nbsp; duration: 1.000 m=
s<o:p></o:p></p>
<p class=3D"MsoNormal">2016-06-17 12:45:05 BST LOG:&nbsp; statement: SAVEPO=
INT _EXEC_SVP_186EB5C8<o:p></o:p></p>
<p class=3D"MsoNormal">2016-06-17 12:45:05 BST LOG:&nbsp; duration: 0.000 m=
s<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I am guessing these statements are causing an overhe=
ad while inserting records in to the table. Could you please let me know if=
 I need to change any configuration settings to avoid creating any save poi=
nts as the transaction is handled
 in the application.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:#1F497D;mso-fare=
ast-language:EN-GB">Regards,</span><span lang=3D"EN-US" style=3D"font-size:=
12.0pt;color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:#1F497D;mso-fare=
ast-language:EN-GB">Eisha Shetty</span><span style=3D"color:#1F497D;mso-far=
east-language:EN-GB"><o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:8.0pt;font-f=
amily:&quot;Tahoma&quot;,sans-serif;color:#1F497D;background:white;mso-fare=
ast-language:EN-GB">ACCENTURE | UK-NEWCASTLE<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:8.0pt;font-family:Wingdings=
;color:#1F497D;mso-fareast-language:EN-GB">(</span><span lang=3D"EN-US" sty=
le=3D"font-size:8.0pt;font-family:&quot;Tahoma&quot;,sans-serif;color:#1F49=
7D;background:white;mso-fareast-language:EN-GB"> &#43;44
 7741587433</span><span lang=3D"EN-US" style=3D"font-size:8.0pt;font-family=
:&quot;Tahoma&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-GB"><o=
:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt"><span style=3D"font-s=
ize:8.0pt;font-family:Wingdings;color:#1F497D;mso-fareast-language:EN-GB">*=
</span><span style=3D"font-size:8.0pt;font-family:&quot;Tahoma&quot;,sans-s=
erif;color:#1F497D;background:white;mso-fareast-language:EN-GB">
</span><span lang=3D"EN-US" style=3D"font-size:8.0pt;font-family:&quot;Taho=
ma&quot;,sans-serif;color:#1F497D;background:white;mso-fareast-language:EN-=
GB"><a href=3D"mailto:e.ratnakar.shetty@accenture.com"><span style=3D"color=
:blue">e.ratnakar.shetty@accenture.com</span></a></span><span style=3D"mso-=
fareast-language:EN-GB"><o:p></o:p></span></p>
<div style=3D"margin-bottom:12.0pt">
<div class=3D"MsoNormal" align=3D"center" style=3D"text-align:center"><span=
 style=3D"mso-fareast-language:EN-GB">
<hr size=3D"2" width=3D"100%" align=3D"center">
</span></div>
</div>
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt"><span style=3D"font-s=
ize:8.0pt;font-family:&quot;Arial&quot;,sans-serif;mso-fareast-language:EN-=
GB">This message is for the designated recipient only and may contain privi=
leged, 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. Whe=
re allowed by local law, electronic communications with Accenture and its a=
ffiliates, including e-mail and
 instant messaging (including content), may be scanned by our systems for t=
he purposes of information security and assessment of internal compliance w=
ith Accenture policy.Accenture means Accenture (UK) Limited (registered num=
ber 4757301), registered in England
 and Wales with registered address at 30 Fenchurch Street, London EC3M 3BD.=
<br>
<br>
</span><span lang=3D"EN-US" style=3D"font-size:8.0pt;font-family:&quot;Taho=
ma&quot;,sans-serif;color:#1F497D;background:white;mso-fareast-language:EN-=
GB"><o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"mso-fareast-language:EN-GB"><o:p>&nbs=
p;</o:p></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt"><span lang=3D"EN-US" =
style=3D"font-size:8.0pt;font-family:&quot;Tahoma&quot;,sans-serif;color:#1=
F497D;background:white;mso-fareast-language:EN-GB"><o:p>&nbsp;</o:p></span>=
</p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
</body>
</html>

--_000_632c061e261d478699e48af2a24363a7CO2PR4202MB0281048dmgdm_--