Re: Slow W7 64 ODBC connection - Mailing list pgsql-novice

From Tom Lane
Subject Re: Slow W7 64 ODBC connection
Date
Msg-id 20507.1343916537@sss.pgh.pa.us
Whole thread Raw
In response to Slow W7 64 ODBC connection  ("Achim Jansen, Promax VPM" <info@promax-vpm.com>)
List pgsql-novice
"Achim Jansen, Promax VPM" <info@promax-vpm.com> writes:
> a client of mine is complaining about a slow ODBC driver connection on
> his Windows 7 64 bit PC. He is using an MS Access 2002 Database connected
> via a Postgres ODBC driver version 9.00.03.00 to a PostgreSQL database
> server version 7.4.19 on a web server. When connecting from a W7 32 bit
> everything works fine and fast.

One theory you should check into right away is the possibility that
something is broken about DNS name resolution on the W64 machine.
That very often manifests as slow hostname lookup and hence slow
connections.

If that's not it, you'd probably have better luck asking on the
pgsql-odbc list.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: Really easy problem...
Next
From: James David Smith
Date:
Subject: Understanding sequence function