5.1.6.9. PostGre SQL Setup

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.1. General Parameters used in many actions > 5.1.6. ODBC Connections >

5.1.6.9. PostGre SQL Setup

 
The official link to download the PostgreSQL ODBC drivers is here:

https://www.postgresql.org/ftp/odbc/versions/msi/

 

For your convenience, a copy of the ODBC drivers is here:

http://download.timi.eu/ODBC/ODBC_drivers_PostgreSQL/

 
We won’t give any details about the installation of the ODBC driver because it’s straightforward. When using PostgreSQL, you have the choice between using an “ANSI” or using an “Unicode” ODBC driver: you should use the “Unicode” ODBC driver.

 

When using PostgreSQL, the “insert” speed is particularly slow compared to other databases (for example, despite using the “trick” given here below, PostgreSQL “insert’s” are still around 20 times slower than MS-SQL-Server “insert’s”). To get a better “insert” speed:
 

1.Open the configuration panel of the PostgreSQL ODBC driver inside the ODBC Manager and click on the “Datasource” button:
 

clip0966

 
 

2.Increase the “batch size” parameter to “10000” (or higher):

 

img1111

 
 

3. Click the “OK” button