| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "A(dot) Mous" <a(dot)mous(at)shaw(dot)ca> |
| Cc: | "'Richard Huxton'" <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Simple query takes a long time on win2K |
| Date: | 2005-03-23 16:51:02 |
| Message-ID: | 7596.1111596662@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers-win32 |
"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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-03-23 16:52:38 | Re: I'm OWNER of the db but I get `permission denied` when |
| Previous Message | Tzahi Fadida | 2005-03-23 16:50:46 | Existence of tuples in relations and a multicolumn index. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Mous | 2005-03-23 17:02:01 | Re: Simple query takes a long time on win2K |
| Previous Message | A. Mous | 2005-03-23 16:40:19 | Re: Simple query takes a long time on win2K |