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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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