Skip site navigation (1) Skip section navigation (2)

Re: Simple query takes a long time on win2K

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,"'Magnus Hagander'" <mha(at)sollentuna(dot)net>,"'Joshua D(dot) Drake'" <jd(at)commandprompt(dot)com>,"'Lincoln Yeoh'" <lyeoh(at)pop(dot)jaring(dot)my>,pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: Simple query takes a long time on win2K
Date: 2005-03-23 18:11:18
Message-ID: 8594.1111601478@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers-win32
"A. Mous" <a(dot)mous(at)shaw(dot)ca> 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.

In response to

pgsql-hackers-win32 by date

Next:From: Magnus HaganderDate: 2005-03-23 19:04:12
Subject: Re: Simple query takes a long time on win2K
Previous:From: A. MousDate: 2005-03-23 18:05:16
Subject: Re: Simple query takes a long time on win2K

pgsql-general by date

Next:From: Tom LaneDate: 2005-03-23 18:36:33
Subject: Re: [GENERAL] contrib module intagg crashing the backend
Previous:From: A. MousDate: 2005-03-23 18:05:16
Subject: Re: Simple query takes a long time on win2K

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group