X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BECD8D8D8C for ; Wed, 14 Sep 2005 10:02:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98910-06 for ; Wed, 14 Sep 2005 13:02:31 +0000 (GMT) Received: from www.epot.cz (sramek.casablanca.cz [81.0.254.161]) by svr1.postgresql.org (Postfix) with ESMTP id C80B1D8D71 for ; Wed, 14 Sep 2005 10:02:30 -0300 (ADT) Received: from www.epot.cz (localhost [127.0.0.1]) by www.epot.cz (8.13.3/8.12.10) with ESMTP id j8ED2QDd019952; Wed, 14 Sep 2005 15:02:26 +0200 (CEST) (envelope-from dali@insula.cz) Received: (from xsramek01@localhost) by www.epot.cz (8.13.3/8.12.10/Submit) id j8ED2MIY019950; Wed, 14 Sep 2005 15:02:22 +0200 (CEST) (envelope-from dali@insula.cz) X-Authentication-Warning: www.epot.cz: xsramek01 set sender to dali@insula.cz using -f Date: Wed, 14 Sep 2005 15:02:22 +0200 From: Dalibor Sramek To: Merlin Moncure Cc: pgsql-performance@postgresql.org Subject: Re: Low performance on Windows problem Message-ID: <20050914130221.GA18466@www.epot.cz> References: <6EE64EF3AB31D5448D0007DD34EEB3417DD31A@Herge.rcsinc.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD31A@Herge.rcsinc.local> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned-By: Clam AntiVirus - OK X-Scanned-By: MIMEDefang 2.52 on 81.0.254.161 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/186 X-Sequence-Number: 14494 On Tue, Sep 13, 2005 at 11:05:00AM -0400, Merlin Moncure wrote: > 5. do select array_accum(q::text) from generate_series(1,10000) q; I made the tests you suggested and the pattern is clear. The difference between local and remote command execution is caused by moving data over the network. E.g. the command above takes 700 ms locally and 1500 ms remotely. Remote explain analyze takes exactly the 700 ms. I downloaded PCATTCP - http://www.pcausa.com/Utilities/pcattcp.htm and the measured throughput between the two machines is over 10000 kB/s. PCATTCP allows setting TCP_NODELAY but it had no effect on the transfer speed. So the difference between local and remote execution should IMHO stay in the 10 ms range. Definitely not 800 ms. The 8.1 has the same problem. Just for the record: the server PC is Dell Precision 330 with 3Com 3C920 integrated network card. OS MS Windows Professional 2002 with service pack 2. There is Symantec Antivirus installed - which I have (hopefully) completely disabled. Thanks for any help Dalibor Sramek -- Dalibor Sramek http://www.insula.cz/dali \ In the eyes of cats / dalibor.sramek@insula.cz \ all things / >H blog http://www.transhumanismus.cz/blog.php \ belong to cats.