Skip site navigation (1) Skip section navigation (2)

Re: TCP network cost

From: Rusty Conover <rconover(at)infogears(dot)com>
To: Ross J(dot) Reedstrom <reedstrm(at)rice(dot)edu>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: TCP network cost
Date: 2009-02-17 20:59:55
Message-ID: B7A2E4DA-A137-46F5-8643-2EF3772F4D2C@infogears.com (view raw or flat)
Thread:
Lists: 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
--
Rusty Conover
rconover(at)infogears(dot)com
InfoGears Inc / GearBuyer.com / FootwearBuyer.com
http://www.infogears.com
http://www.gearbuyer.com
http://www.footwearbuyer.com







In response to

Responses

pgsql-performance by date

Next:From: Ross J. ReedstromDate: 2009-02-17 21:14:55
Subject: Re: TCP network cost
Previous:From: Ross J. ReedstromDate: 2009-02-17 20:04:17
Subject: Re: TCP network cost

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group