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 692D69DC9B3
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 21 Dec 2005 05:05:17 -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 72753-05
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 21 Dec 2005 05:05:17 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from alatxa.lapeixera.org (unknown [212.31.60.122])
	by postgresql.org (Postfix) with ESMTP id 1A6449DC813
	for <pgsql-performance@postgresql.org>;
	Wed, 21 Dec 2005 05:05:13 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by alatxa.lapeixera.org (Postfix) with ESMTP id E766073CD2
	for <pgsql-performance@postgresql.org>;
	Wed, 21 Dec 2005 10:04:58 +0100 (CET)
Received: from alatxa.lapeixera.org ([127.0.0.1])
	by localhost (alatxa [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 06323-01 for <pgsql-performance@postgresql.org>;
	Wed, 21 Dec 2005 10:04:48 +0100 (CET)
Received: from [10.2.2.28] (unknown [10.2.2.28])
	by alatxa.lapeixera.org (Postfix) with ESMTP id 0957373C8E
	for <pgsql-performance@postgresql.org>;
	Wed, 21 Dec 2005 10:04:48 +0100 (CET)
Message-ID: <43A91ABE.9070000@endepro.com>
Date: Wed, 21 Dec 2005 10:05:02 +0100
From: Josep Maria Pinyol Fontseca <jmpinyol@endepro.com>
Organization: Endepro
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
X-Accept-Language: ca
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Windows performance again
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at lapeixera.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0 required=5 tests=[none]
X-Spam-Score: 0
X-Spam-Level: 
X-Archive-Number: 200512/527
X-Sequence-Number: 16348

Hello,

We have the next scenario:

Linux box with postgresql 7.2.1-1 (client)
Windows XP with postgresql 8.1.1 (server)
Windows XP with postgresql 8.1.1 (client)

All connected in 10Mb LAN

In server box, we have a table with 65000 rows and usign "psql" we have 
these results:

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%

Is a really problem, because we are migrating a old server to 8.0 
version in a windows box, and our application works really slow....

Thanks in advance,

Josep Maria

-- 

Josep Maria Pinyol i Fontseca
Responsable àrea de programació

ENDEPRO - Enginyeria de programari
Passeig Anselm Clavé, 19 Bx. 08263 Callús (Barcelona)
Tel. +34 936930018 - Mob. +34 600310755 - Fax. +34 938361994
jmpinyol@endepro.com - http://www.endepro.com


Aquest missatge i els documents en el seu cas adjunts, 
es dirigeixen exclusivament al seu destinatari i poden contenir 
informació reservada i/o CONFIDENCIAL, us del qual no està 
autoritzat ni la divulgació del mateix, prohibit per la legislació 
vigent (Llei 32/2002 SSI-CE). Si ha rebut aquest missatge per error, 
li demanem que ens ho comuniqui immediatament per la mateixa via o 
bé per telèfon (+34936930018) i procedeixi a la seva destrucció. 
Aquest e-mail no podrà considerar-se SPAM.

Este mensaje, y los documentos en su caso anexos, 
se dirigen exclusivamente a su destinatario y pueden contener 
información reservada y/o CONFIDENCIAL cuyo uso no 
autorizado o divulgación está prohibida por la legislación 
vigente (Ley 32/2002 SSI-CE). Si ha recibido este mensaje por error, 
le rogamos que nos lo comunique inmediatamente por esta misma vía o 
por teléfono (+34936930018) y proceda a su destrucción. 
Este e-mail no podrá considerarse SPAM.

This message and the enclosed documents are directed exclusively 
to its receiver and can contain reserved and/or confidential 
information, from which use isn’t allowed its divulgation, forbidden 
by the current legislation (Law 32/2002 SSI-CE). If you have received 
this message by mistake, we kindly ask you to communicate it to us 
right away by the same way or by phone (+34936930018) and destruct it. 
This e-mail can’t be considered as SPAM.