This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Has anyone had any success configuring the ODBC driver to allow for faster read/ writes into Postgres? We are running 9.4 and using the standard ODBC driver from Postgres and read/ write times are so slow compared to similar functions connected to SQL Server. We have tried converting data types from text to varchar and other tweaks like that but are still finding it to be several times slower than expected.
Is there a commercial ODBC driver that is recommended or particular configuration to increase speeds? Thanks
I realized that to specify a specific schema and table you have to use "schema name.table name".
The problem I was having was two fold, my driver was not fully supported so I upgraded. The second part was I was not being able to change my field mapping from "map by name" to "custom mapping" and map all the fields appropriately.