From: Reshma Toppo <Reshma.Toppo@ice.com>
To: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Subject: Understanding plsqlODBC Configuration Options while connecting SSIS
 to Postgres database
Thread-Topic: Understanding plsqlODBC Configuration Options while connecting
 SSIS to Postgres database
Thread-Index: AdeVyC0m5SQfqEv6Qpeimo73FtoI6Q==
Date: Fri, 20 Aug 2021 13:40:13 +0000
Message-ID: 
 <SJ0PR06MB7210BBA0931832A4999E078D80C19@SJ0PR06MB7210.namprd06.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?5vBmwOzaNDK1ZwLnmW9GN7+EhMle58E5ilHTglm3JsAfXNpXmOTLAvdZNhbS?=
 =?us-ascii?Q?ALOxVR6QB4hBRwUNPJolq1EOutsBV6+3cr/oBuwmj26XyuQoONkb+8GEf9ay?=
 =?us-ascii?Q?kbd3MH0cn6x9+FGah6ZnPxj/n0UE6VHsW4jhlelxGWo0VzxDkm6uPlliOHJF?=
 =?us-ascii?Q?gH6AYs54PGfkFPGPbCkfZS3tsP3rczqn//DbhJVNcynqMOkcMeFTwF0Zlk7a?=
 =?us-ascii?Q?aPGC7pPYFQN/xPSPJGn59BsfoJisvdOouyN5UKk+so9tSD3RsbCQYOALZTSw?=
 =?us-ascii?Q?goOZVah+oaFfl+Ib1yaPr7uOqOyvQgR+ubFhu4lkD0lvqYHPHBPHJx9B7zph?=
 =?us-ascii?Q?8P5LCxpX2hEgpmhEEXpUKSfN3ZaRcEVcOeBjSpUkipBx6Sxwyz3QKYpCiCjU?=
 =?us-ascii?Q?chSsAjEy3YYdvocmhOGBLJWStfRQymkNneim3vEhqLTYlsmMro4ExtQ3H3vi?=
 =?us-ascii?Q?byT5DcJOFt+/Bj0QsOglOwAeH/NowLqk4Ek+GfspUZpHS01c3b9jF8wdcexE?=
 =?us-ascii?Q?R8573kB2oNibm33fBsFI4qs6WoohBaKbEjJJ9eYFkV04lVYS5EWZ1uCcX5nk?=
 =?us-ascii?Q?NDYO6WNmhj7RNbt9zoPdOjssvxdfM45ELcGwRIrLGQigLmshUtFoCR/mcOsU?=
 =?us-ascii?Q?HBm5EDbMRrluVkVwzhtuxjXvzGSKF9lzOMDJOKLKrBSJyuuPgTrzXqVnPy3Y?=
 =?us-ascii?Q?1xIfoyTaamfUYwApnKH6QwDdyfJhZDnAxgaVQRQbcV3OXT7CYKr935LHh/3v?=
 =?us-ascii?Q?jMe5/5KVlCPBoy0iwIhqLc95WSaDSqJI9Grs40V61DZrXFuGJ3RKTRSqmeTC?=
 =?us-ascii?Q?3TjybTMs2HXv/B3JQkpdtGQDtRZgfA+bBtKOaszAraG2peaKFITNqp5p5m9A?=
 =?us-ascii?Q?UkgSgN2l6n/2UF8Fb521h0ZnVnOo/j3560yn4DiCH1T6N+2dy2Ir6CgUjCuQ?=
 =?us-ascii?Q?KG1r2zqqb2SYC1N4pPfQiNkRUNK1oIKc76wlPVzgbYzKxjZXGMPgswAnA365?=
 =?us-ascii?Q?5tiyJvEeL37k6qEXoJ1HSZYGF0DJgtj1FXgCUeFto1JbGOr1X8vF3Dt+nbX+?=
 =?us-ascii?Q?V9yG7qy+TB2R4gfdLSrz06V2y5QZVECRDYbnjAyGUCgvIbVdCXL1j0itEX8/?=
 =?us-ascii?Q?U4a55HS0JLENQyN7EY3pNoCc4RK5HGua8jcIOgjqwaKvQMdNatIQGEvPQmYY?=
 =?us-ascii?Q?P4mg8az+W+iX5z5FhVCAlSM2gC3H1SEEjCy8rWH84t65iq0uJwko+z132fjt?=
 =?us-ascii?Q?r08ZvqPa4LePXdKrQo1RybRP0A8YB0igqDypX1fasHnAKTZqoL2BqRD+K8vB?=
 =?us-ascii?Q?L5JGJrR8Plp4356bL0IImFZy?=
x-ms-exchange-transport-forked: True
Content-Type: multipart/alternative;
	boundary="_000_SJ0PR06MB7210BBA0931832A4999E078D80C19SJ0PR06MB7210namp_"
MIME-Version: 1.0
X-OriginatorOrg: ice.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: SJ0PR06MB7210.namprd06.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 25ef4dd6-b03f-455d-71f1-08d963e009c1
X-MS-Exchange-CrossTenant-originalarrivaltime: 20 Aug 2021 13:40:13.6166
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 0d009d13-c2cd-47d8-91dd-2ae838b00d4b
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 plxtm5um1NxXadnvARDksACj1mNNK/VIvjGZJ0hKAeV59eJNEdq4nXHFYPitXRaeADOKD5QA4wyvEoWhhqZBFNDActl14ak+coFi6jZSYXc=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BYAPR06MB6152
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/SJ0PR06MB7210BBA0931832A4999E078D80C19%40SJ0PR06MB7210.namprd06.prod.outlook.com>
Precedence: bulk

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

Hi,

We have a BI tool extracting data from Postgres database . We are using con=
nection string to connect to Postgres database from a BI tool. Connection i=
s working fine. Successfully extracting data. However, the data extraction =
is slow. We want to have a deeper understanding of these Connection String =
options more so that performance can be improved

Help will be greatly appreciated

Connection String we are using:
"Driver=3D{PostgreSQL Unicode};server=3D"+ @[$Project::SourceServer] +";uid=
=3D"+ @[$Project::SourceDBUserName] +";initial catalog=3D"+ @[$Project::Sou=
rceDBName]+";database=3D"+ @[$Project::SourceDBName] +";port=3D"+@[$Project=
::SourcePort]+";sslmode=3Dprefer;readonly=3D1;protocol=3D7.4;fakeoidindex=
=3D0;showoidcolumn=3D0;rowversioning=3D0;showsystemtables=3D0;fetch=3D1000;=
unknownsizes=3D0;maxvarcharsize=3D8000;maxlongvarcharsize=3D8190;debug=3D0;=
commlog=3D0;usedeclarefetch=3D1;textaslongvarchar=3D1;unknownsaslongvarchar=
=3D1;boolsaschar=3D0;parse=3D0;lfconversion=3D1;updatablecursors=3D1;trueis=
minus1=3D0;bi=3D2;byteaaslongvarbinary=3D1;useserversideprepare=3D1;lowerca=
seidentifier=3D0;d6=3D8;optionalerrors=3D0;xaopt=3D1"

This is the Postgres documentation that I referred for setting the values f=
or connection options in the connection string
https://odbc.postgresql.org/docs/config.html


Thanks & Regards
Reshma G Toppo
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DNotice to Recipient: This e-mail tra=
nsmission, and any documents, files or previous e-mail messages attached to=
 it may contain information that is confidential or legally privileged, and=
 intended for the use of the individual or entity named above. If you are n=
ot the intended recipient, or a person responsible for delivering it to the=
 intended recipient, you are hereby notified that you must not read this tr=
ansmission and that any disclosure, copying, printing, distribution or use =
of any of the information contained in or attached to this transmission is =
STRICTLY PROHIBITED. If you have received this transmission in error, pleas=
e immediately notify the sender by telephone or return e-mail and delete th=
e original transmission and its attachments without reading or saving in an=
y manner. Thank you. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

--_000_SJ0PR06MB7210BBA0931832A4999E078D80C19SJ0PR06MB7210namp_
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:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:m=3D"http://schema=
s.microsoft.com/office/2004/12/omml" xmlns=3D"http://www.w3.org/TR/REC-html=
40">
<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)">
<style><!--
/* Font Definitions */
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	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;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
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-US" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<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">We have a BI tool extracting data from Postgres data=
base . <span style=3D"font-size:11.5pt;font-family:&quot;Arial&quot;,sans-s=
erif;color:#1D1C1D;background:#F8F8F8">
We are using connection string to connect to Postgres database from a BI to=
ol. Connection is working fine. Successfully extracting data. However, the =
data extraction is slow. We want to have a deeper understanding of these Co=
nnection String options more so
 that performance can be improved<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.5pt;font-family:&quot;Ar=
ial&quot;,sans-serif;color:#1D1C1D;background:#F8F8F8"><o:p>&nbsp;</o:p></s=
pan></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.5pt;font-family:&quot;Ar=
ial&quot;,sans-serif;color:#1D1C1D;background:#F8F8F8">Help will be greatly=
 appreciated<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.5pt;font-family:&quot;Ar=
ial&quot;,sans-serif;color:#1D1C1D;background:#F8F8F8"><o:p>&nbsp;</o:p></s=
pan></p>
<p class=3D"MsoNormal"><i><u><span style=3D"font-size:11.5pt;font-family:&q=
uot;Arial&quot;,sans-serif;color:#1D1C1D;background:#F8F8F8">Connection Str=
ing we are using:<o:p></o:p></span></u></i></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.5pt;font-family:&quot;Ar=
ial&quot;,sans-serif;color:#1D1C1D;background:#F8F8F8">&quot;Driver=3D{Post=
greSQL Unicode};server=3D&quot;+ @[$Project::SourceServer] +&quot;;uid=3D&q=
uot;+ @[$Project::SourceDBUserName] +&quot;;initial catalog=3D&quot;+ @[$Pr=
oject::SourceDBName]+&quot;;database=3D&quot;+
 @[$Project::SourceDBName] +&quot;;port=3D&quot;+@[$Project::SourcePort]+&q=
uot;;sslmode=3Dprefer;readonly=3D1;protocol=3D7.4;fakeoidindex=3D0;showoidc=
olumn=3D0;rowversioning=3D0;showsystemtables=3D0;fetch=3D1000;unknownsizes=
=3D0;maxvarcharsize=3D8000;maxlongvarcharsize=3D8190;debug=3D0;commlog=3D0;=
usedeclarefetch=3D1;textaslongvarchar=3D1;unknownsaslongvarchar=3D1;boolsas=
char=3D0;parse=3D0;lfconversion=3D1;updatablecursors=3D1;trueisminus1=3D0;b=
i=3D2;byteaaslongvarbinary=3D1;useserversideprepare=3D1;lowercaseidentifier=
=3D0;d6=3D8;optionalerrors=3D0;xaopt=3D1&quot;</span><o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><i><u><span style=3D"font-size:11.5pt;font-family:&q=
uot;Arial&quot;,sans-serif;color:#1D1C1D;background:#F8F8F8">This is the Po=
stgres documentation that I referred for setting the values for connection =
options in the connection string<o:p></o:p></span></u></i></p>
<p class=3D"MsoNormal"><a href=3D"https://odbc.postgresql.org/docs/config.h=
tml" target=3D"_blank"><span style=3D"font-size:11.5pt;font-family:&quot;Ar=
ial&quot;,sans-serif;background:#F8F8F8;text-decoration:none">https://odbc.=
postgresql.org/docs/config.html</span></a><o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks &amp; Regards<o:p></o:p></p>
<p class=3D"MsoNormal">Reshma G Toppo<o:p></o:p></p>
</div>
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DNotice to Recipient: This e-mail tra=
nsmission, and any documents, files or previous e-mail messages attached to=
 it may contain information that is confidential or legally privileged, and=
 intended for the use of the individual or entity named above.
 If you are not the intended recipient, or a person responsible for deliver=
ing it to the intended recipient, you are hereby notified that you must not=
 read this transmission and that any disclosure, copying, printing, distrib=
ution or use of any of the information
 contained in or attached to this transmission is STRICTLY PROHIBITED. If y=
ou have received this transmission in error, please immediately notify the =
sender by telephone or return e-mail and delete the original transmission a=
nd its attachments without reading
 or saving in any manner. Thank you. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
</body>
</html>

--_000_SJ0PR06MB7210BBA0931832A4999E078D80C19SJ0PR06MB7210namp_--