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 230689DCC8F for ; Fri, 2 Dec 2005 17:08:02 -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 23866-08 for ; Fri, 2 Dec 2005 17:07:58 -0400 (AST) X-Greylist: delayed 03:43:23.230408 by SQLgrey- Received: from alatxa.lapeixera.org (unknown [212.31.60.122]) by postgresql.org (Postfix) with ESMTP id DB28F9DCAE2 for ; Fri, 2 Dec 2005 17:07:58 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by alatxa.lapeixera.org (Postfix) with ESMTP id 3935973CD5; Fri, 2 Dec 2005 22:06:16 +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 04403-03; Fri, 2 Dec 2005 22:06:06 +0100 (CET) Received: from [192.168.1.12] (188.Red-81-35-125.dynamicIP.rima-tde.net [81.35.125.188]) by alatxa.lapeixera.org (Postfix) with ESMTP id AEA3773CD2; Fri, 2 Dec 2005 22:06:05 +0100 (CET) Message-ID: <4390B7CB.2030402@endepro.com> Date: Fri, 02 Dec 2005 22:08:27 +0100 From: Josep Maria Pinyol Fontseca Organization: ENDEPRO User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Qingqing Zhou Cc: pgsql-performance@postgresql.org Subject: Re: Network permormance under windows References: <6EE64EF3AB31D5448D0007DD34EEB3417DD9EA@Herge.rcsinc.local> <43908337.5060605@endepro.com> In-Reply-To: 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/78 X-Sequence-Number: 15899 Yes, with psql, pgAdminIII and our application with ODBC I experiment the same situation... the sentences that I execute are like "select * ..." or similar like this. Qingqing Zhou wrote: >"Josep Maria Pinyol Fontseca" wrote > > >>When we select all data in local machine, we obtain results in 2-3 seconds >>aprox. In remote connections: >> >>Postgresql 7.1 usign pgAdminII: >>Network traffic generated with remote applications is about 77-80% in a >>10Mb connection. >>6 seconds aprox. >> >>Postgresql 8.1 usign pgAdminIII: >>Network traffic generated with remote applications is about 2-4% in a 10Mb >>connection. >>12 seconds or more... >> >> >> > >Have you tried to use psql? And how you "select all data" - by "select >count(*)" or "select *"? > >Regards, >Qingqing > > > >---------------------------(end of broadcast)--------------------------- >TIP 2: Don't 'kill -9' the postmaster > > -- 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.