Re: TCP network cost - Mailing list pgsql-performance

From Rusty Conover
Subject Re: TCP network cost
Date
Msg-id B7A2E4DA-A137-46F5-8643-2EF3772F4D2C@infogears.com
Whole thread Raw
In response to Re: TCP network cost  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Responses Re: TCP network cost
List pgsql-performance

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.




What is the client software you're using?  libpq?  

Rusty

pgsql-performance by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: TCP network cost
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: TCP network cost