Re: 10 row/second insert in ssis

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