Re: [GENERAL] Simple query takes a long time on win2K
Tom Lane <[email protected]> Wed, 23 Mar 2005 13:11:18 -0500
| Newsgroups | gmane.comp.db.postgresql.devel.win32,gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
"A. Mous" <[email protected]> writes: > 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. I really thought the QoS thing would be it. Maybe there was some other thing to do, configuration-wise, to make that do its thing properly? If you could reproduce this behavior across the network I would tell you to get out a packet analyzer (ethereal or some such) and sniff the traffic to learn more. Are there any programs that can sniff local TCP traffic on win2k? regards, tom lane PS: I've added pgsql-hackers-win32 to the cc list. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster