X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 375C59DC80C
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 21 Dec 2005 06:04:37 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 90971-05
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 21 Dec 2005 06:04:38 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75])
	by postgresql.org (Postfix) with ESMTP id CB7AF9DC823
	for <pgsql-performance@postgresql.org>;
	Wed, 21 Dec 2005 06:04:34 -0400 (AST)
Received: from mainbox.archonet.com
	(84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99])
	by smtp.metronet.co.uk (MetroNet Mail) with ESMTP
	id EE941424FDC; Wed, 21 Dec 2005 09:58:43 +0000 (GMT)
Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP id 0B3D515EA4;
	Wed, 21 Dec 2005 09:58:49 +0000 (GMT)
Message-ID: <43A92758.6060709@archonet.com>
Date: Wed, 21 Dec 2005 09:58:48 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 1.5 (X11/20051025)
MIME-Version: 1.0
To: Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Windows performance again
References: <43A91ABE.9070000@endepro.com>
In-Reply-To: <43A91ABE.9070000@endepro.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.016 required=5 tests=[AWL=0.016]
X-Spam-Score: 0.016
X-Spam-Level: 
X-Archive-Number: 200512/528
X-Sequence-Number: 16349

Josep Maria Pinyol Fontseca wrote:
> 
> Linux box with psql version 7.2.1 versus Windows XP server:
> 
> select * from <table>; -> 7 seconds aprox. to obtain a results.
> Network utilization: 100%
> 
> Windows XP client box with psql version 8.1.1 versus Windows XP server:
> 
> select * from <table>; -> 60 seconds aprox. to obtain a results!!!!!!!!!!!!
> Network utilization: 3%
> 
> Windows XP server box with psql version 8.1.1 versus Windows XP server:
> 
> select * from <table>; -> <1 seconds aprox. to obtain a results.
> Network utilization: 0%

It's *got* to be the network configuration on the client machine. I'd be 
tempted to install ethereal on the linux box and watch for the 
difference between the two networked sessions.

I'm guessing it might be something to do with TCP/IP window/buffer sizes 
and delays on ACKs - this certainly used to be an issue on older MS 
systems, but I must admit I thought they'd fixed it for XP.

If not that, could some firewall/security system be slowing network traffic?

-- 
   Richard Huxton
   Archonet Ltd