Skip site navigation (1) Skip section navigation (2)

Re: ODBC driver over network very slow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Milan Sekanina <milan(at)sde(dot)cz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: ODBC driver over network very slow
Date: 2005-06-30 13:48:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Milan Sekanina <milan(at)sde(dot)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

In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2005-06-30 14:10:25
Subject: Re: ODBC driver over network very slow
Previous:From: Tom LaneDate: 2005-06-30 13:31:01
Subject: Re: Vacuum becomes slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group