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