On Feb 17, 2009, at 1:04 PM, Ross J. Reedstrom wrote:
On Tue, Feb 17, 2009 at 12:20:02AM -0700, Rusty Conover wrote:
Try running tests with ttcp to eliminate any PostgreSQL overhead and
find out the real bandwidth between the two machines. If its results
are also slow, you know the problem is TCP related and not PostgreSQL
related.
I did in fact run a simple netcat client/server pair and verified that I can transfer that file on 0.12 sec localhost (or hostname), 0.35 over the net, so TCP stack and network are not to blame. This is purely inside the postgresql code issue, I believe.