New version of OLEDB provider for PostgreSQL database includes following features and enhancements:
Ability to work with multiple databases via single Linked Server connection.
Support for SSL and SSPI.
Support for arrays.
Enhanced expression types evaluator.
Support for nested transactions.
Support for distributed transactions (DTC enlistment).
New profiler application.
Optimizations for insertion of large amounts of data into database.
Support for Command Timeout.
Redesigned "Data Link Properties" pages for easier configuration of connection string.
The profiler application is needed for various reasons. Among them:
1) Developer and DB administrator want to see which commands are sent to OLEDB Provider and what statements the Provider is sending to the Postgres server.
2) The timing information can be used to identify statements for optimization.
3) No permissions/rights are necessary to monitor Postgres server log. Local and remote hosts can be monitored by the Profiler (only for applications that use the PGNP Provider).
Some enhancements in PGNP Provider are related to support of very large databases using PostgreSQL server cursors. New code was written to support Linked Servers' work with tables containing millions of rows and to support COPY-based bulk import into databases.
Developers site: http://www.pgoledb.com
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.