Re: TCP network cost

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.