After some testing using wiershark (poor mans profiler) to see what was
going on with the network I found that it was the tools I've been
using. Both Aqua and PGadminIII have a large overhead per column to
get the meta data. MSSQL sends that data upfront so the impact isn't
as bad. I'm not sure if it's a limitation of the pgsql protocol vs
tds or a limitation of Aqua or a combination of both. At any rate it
turns out not to be part of the problem I'm having with my software
stalling out so I'm back to Square one with my problem. Thanks, Ron |