Hi,
We have a BI tool extracting data from Postgres database . We are using connection string to connect to Postgres database from a BI tool. Connection is 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={PostgreSQL Unicode};server="+ @[$Project::SourceServer] +";uid="+ @[$Project::SourceDBUserName] +";initial catalog="+ @[$Project::SourceDBName]+";database="+ @[$Project::SourceDBName] +";port="+@[$Project::SourcePort]+";sslmode=prefer;readonly=1;protocol=7.4;fakeoidindex=0;showoidcolumn=0;rowversioning=0;showsystemtables=0;fetch=1000;unknownsizes=0;maxvarcharsize=8000;maxlongvarcharsize=8190;debug=0;commlog=0;usedeclarefetch=1;textaslongvarchar=1;unknownsaslongvarchar=1;boolsaschar=0;parse=0;lfconversion=1;updatablecursors=1;trueisminus1=0;bi=2;byteaaslongvarbinary=1;useserversideprepare=1;lowercaseidentifier=0;d6=8;optionalerrors=0;xaopt=1"
This is the Postgres documentation that I referred for setting the values for connection options in the connection string
https://odbc.postgresql.org/docs/config.html
Thanks & Regards
Reshma G Toppo
=============Notice to Recipient: This e-mail transmission, 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 delivering it to the intended recipient, you are hereby notified that you must not read this transmission 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, please immediately notify the sender by telephone or return e-mail and delete the original transmission and its attachments without reading or saving in any manner. Thank you. =============