From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: dali@insula.cz
To: merlin.moncure@rcsonline.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Low performance on Windows problem
Date: Tue, 13 Sep 2005 10:01:13 -0500
Message-ID: <s326a375.044@gwmta.wicourts.gov> (raw)
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?
-Kevin
>>> Dalibor Sramek <dali@insula.cz> 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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, dali@insula.cz, merlin.moncure@rcsonline.com
Subject: Re: Low performance on Windows problem
In-Reply-To: <s326a375.044@gwmta.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox