Record insertion is done via an ODBC call to a stored procedure from a Windows based host monitor"
I wondered what this stored procedure was (is it a function or something outside postgresql).
There was an interesting article on odbc - that application code can make big differences in database related performance. http://ourworld.compuserve.com/homepages/Ken_North/ODBCPERF.HTM
Thought odbc performance might be also a thing to consider but this article seemed to attest otherwise. Hence the question.
Regards, Ben K. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match