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 6C445D8999 for ; Tue, 13 Sep 2005 11:34:25 -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 77779-09 for ; Tue, 13 Sep 2005 14:34:19 +0000 (GMT) Received: from www.epot.cz (sramek.casablanca.cz [81.0.254.161]) by svr1.postgresql.org (Postfix) with ESMTP id 93BC6D7F2B for ; Tue, 13 Sep 2005 11:34:20 -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 j8DEYJQW001149; Tue, 13 Sep 2005 16:34:19 +0200 (CEST) (envelope-from dali@insula.cz) Received: (from xsramek01@localhost) by www.epot.cz (8.13.3/8.12.10/Submit) id j8DEYE0I001147; Tue, 13 Sep 2005 16:34:14 +0200 (CEST) (envelope-from dali@insula.cz) X-Authentication-Warning: www.epot.cz: xsramek01 set sender to dali@insula.cz using -f Date: Tue, 13 Sep 2005 16:34:02 +0200 From: Dalibor Sramek To: Merlin Moncure Cc: pgsql-performance@postgresql.org Subject: Re: Low performance on Windows problem Message-ID: <20050913143401.GA913@www.epot.cz> References: <6EE64EF3AB31D5448D0007DD34EEB3417DD315@Herge.rcsinc.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD315@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/164 X-Sequence-Number: 14472 On Tue, Sep 13, 2005 at 10:20:05AM -0400, Merlin Moncure wrote: > I loaded your dump and was able to select entire table in trivial time > from both pgAdmin and psql shell. I am suspecting some type of tcp > problem here. Can you confirm slow times on unloaded server? Did you run the select remotely on a Windows server? Yes the server load is practically 0. Note the difference between local and remote execution of the command. I think you are right about the network problem possibility. But it is bound to PostgreSQL. MySQL on the same machine (and same database content) had no problem. So are there any known issues with PostgreSQL on Windows sending data to remote hosts connected via ODBC? What should I do to find out more debug info? Thanks 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.