For the sake of further comparison, I added another computer to the comparison. Another Celeron 2400, running win XP again, but only 256MB ram. All records returned to client in 200ms (slightly longer than the 2400 machine with 500MB ram). Recall that the win2K box with 256MB Ram (PIII 1.8) took 4 seconds.
The confusing thing for me is that so far, the only consistent pattern here is that machines running win2k Pro take roughly 4 seconds to deliver the data to the client, while win XP machines perform much better (<200ms to deliver recordset). I've tried installing QoS packet scheduler on win2K pro machines to no avail. For kicks, I'll repeat the tests on the PII 233 machine with WinXP installed. Thank you Tom for pointing out that the EXPLAIN result shows the data is being fetched in under 100ms, but why is it taking so darn long to move that data into the client (be it psql or pgAdminIII)? I'll let you all know how the winXP test on the PII goes. Thank you all for your insights. -----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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
