From: Tom Lane <tgl@sss.pgh.pa.us>
To: Milan Sekanina <milan@sde.cz>
Cc: pgsql-performance@postgresql.org
Subject: Re: ODBC driver over network very slow
Date: Thu, 30 Jun 2005 09:48:19 -0400
Message-ID: <18271.1120139299@sss.pgh.pa.us> (raw)
In-Reply-To: <42C3C967.8060605@sde.cz>
References: <42C3C967.8060605@sde.cz>
Milan Sekanina <milan@sde.cz> writes:
> We are running an application that uses psqlodbc driver on Windows XP to
> connect to a server and for some reason the download of data from the
> server is very slow. We have created a very simple test application that
> inserts a larger amount of data into the database and uses a simple
> "SELECT * from test" to download it back. The INSERT of 10MB takes about
> 4 seconds, while the SELECT takes almost 5 minutes (with basically
> nothing else running on both the network and the two computers). If we
> run the PostgreSQL server on the local machine so that the network is
> not used, both actions are very fast.
I seem to recall having seen similar reports not involving ODBC at all.
Try searching the mailing-list archives, but I think the cases we solved
involved getting rid of third-party add-ons to the Windows TCP stack.
regards, tom lane
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: tgl@sss.pgh.pa.us, milan@sde.cz
Subject: Re: ODBC driver over network very slow
In-Reply-To: <18271.1120139299@sss.pgh.pa.us>
* 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