Re: Simple query takes a long time on win2K - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Simple query takes a long time on win2K
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C713F@algol.sollentuna.se
Whole thread Raw
In response to Simple query takes a long time on win2K  ("A. Mous" <a.mous@shaw.ca>)
Responses Re: Simple query takes a long time on win2K  ("A. Mous" <a.mous@shaw.ca>)
Re: Simple query takes a long time on win2K  ("A. Mous" <a.mous@shaw.ca>)
List pgsql-general
> > 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?

Microsoft ships a network monitor with Win2k Server. Otherwise, just get
ethereal, it works perfectly on win2k.

//Magnus

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] contrib module intagg crashing the backend
Next
From: "FERREIRA William (COFRAMI)"
Date:
Subject: Re: pl/perl problem