Re: Simple query takes a long time on win2K

Yeah, thanks. I did see that post about the QoS and it doesn't help in this
case.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: March 23, 2005 9:51 AM
To: A. Mous
Cc: 'Richard Huxton'; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Simple query takes a long time on win2K

"A. Mous" <a(dot)mous(at)shaw(dot)ca> writes:
> None of these tests were run over a network - all local.

Nonetheless, the client-to-server communication goes through the Windows
TCP stack, because that's the only comm protocol we support on Windows.

Notice that your EXPLAIN ANALYZEs show the query as executing in less
than 100ms even on the slower machine --- so it seems the bottleneck has
to be in sending the results to the client.

I seem to recall threads on the win32-hackers list to the effect that
local TCP performance really sucks on Win2K unless you have the right
patch installed ("QoS" comes to mind, but I didn't pay attention to
details). We probably need to get that info into the FAQ.

regards, tom lane