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.comhttp://www.infogears.comhttp://www.gearbuyer.comhttp://www.footwearbuyer.com