Re: Performance issue

Pascal Van Puymbroeck <pascal.vanpuymbroeck@zenonproductions.be> writes:
> I would like to solve a strange behaviour I encountered using Postgresql
> 8.0.1 on windows.  Connecting to the database is OK, but when running a
> query to the database, its terribly slow.  The fact is that I need the
> database to be running on the same machine, my application is.

There was a recent thread that came to the conclusion that loopback TCP
connections are remarkably slow on Windows unless you've installed the
correct add-on package --- something not tremendously obvious, I think
it was a "QOS" patch or maybe something to do with packet filtering.
Check the archives of the various pgsql lists.  I forget which list but
it was just a couple weeks ago.

            regards, tom lane