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 B8F4DD8D1A for ; Tue, 13 Sep 2005 12:01:31 -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 81388-10 for ; Tue, 13 Sep 2005 15:01:26 +0000 (GMT) Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.91]) by svr1.postgresql.org (Postfix) with ESMTP id 31F29D8D08 for ; Tue, 13 Sep 2005 12:01:25 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Tue, 13 Sep 2005 10:01:25 -0500 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.4 Date: Tue, 13 Sep 2005 10:01:13 -0500 From: "Kevin Grittner" To: , Cc: Subject: Re: Low performance on Windows problem Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 required=5 tests=[AWL=0.005] X-Spam-Level: X-Archive-Number: 200509/166 X-Sequence-Number: 14474 This is sounding suspiciously similar to behavior I've seen with other = types of TCP database connections when the tcp-no-delay option is not on. = Is it possible that the ODBC driver for Windows is not successfully = setting this up? =20 -Kevin =20 =20 >>> Dalibor Sramek 09/13/05 9:34 AM >>> 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?