Yeah, thanks. I did see that post about the QoS and it doesn't help in this case.
-----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: March 23, 2005 9:51 AM To: A. Mous Cc: 'Richard Huxton'; pgsql-general@postgresql.org Subject: Re: [GENERAL] Simple query takes a long time on win2K "A. Mous" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
