| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Achim Jansen, Promax VPM" <info(at)promax-vpm(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Slow W7 64 ODBC connection |
| Date: | 2012-08-02 14:08:57 |
| Message-ID: | 20507.1343916537@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
"Achim Jansen, Promax VPM" <info(at)promax-vpm(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James David Smith | 2012-08-03 13:59:01 | Understanding sequence function |
| Previous Message | Oliveiros d'Azevedo Cristina | 2012-08-02 12:46:57 | Re: Really easy problem... |