Understanding plsqlODBC Configuration Options while connecting SSIS to Postgres database

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