Hello, Bill,
10 row inserts/s is very slow, isn't it? Let's where the slow spot is.
* To know how long the server takes to execute inserts, add "log_min_duration_statement = 0" in postgresql.conf. This
willrecord timing infomation like this in the server log:
LOG: duration: 129.236 ms statement: insert into a values(1);
* To know how long for what the ODBC driver takes, enable logging by adding the following registry values and
restartingthe application (SSIS?):
key: {HKEY_LOCAL_MACHINE or HKEY_CURRENT_USER}\SOFTWARE\ODBC\ODBC.INI\<your_DSN>
value:
CommLog: REG_DWORD: 1
Debug: REG_DWORD: 1
Logdir: REG_SZ: folder path where you want to store the log files
This will create psqlodbc_<pid>.log and mylog_<pid>.log in the specified folder. <pid> is the process ID of the
applicationusing ODBC. If not found, the log files may be stored in the following places:
* C:\
* C:\podbclog
* %HOMEDRIVE%%HOMEPATH%
Regards
Takayuki Tsunakawa
