From: Dalibor Sramek <dali@insula.cz>
To: Merlin Moncure <merlin.moncure@rcsonline.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Low performance on Windows problem
Date: Tue, 13 Sep 2005 16:34:02 +0200
Message-ID: <20050913143401.GA913@www.epot.cz> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD315@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD315@Herge.rcsinc.local>
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.
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: dali@insula.cz, merlin.moncure@rcsonline.com
Subject: Re: Low performance on Windows problem
In-Reply-To: <20050913143401.GA913@www.epot.cz>
* 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