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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: [GENERAL] Simple query takes a long time on win2K


  • From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
  • To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "A. Mous" <a(dot)mous(at)shaw(dot)ca>
  • Cc: "Richard Huxton" <dev(at)archonet(dot)com>, <pgsql-general(at)postgresql(dot)org>, "Joshua D. Drake" <jd(at)commandprompt(dot)com>, "Lincoln Yeoh" <lyeoh(at)pop(dot)jaring(dot)my>, <pgsql-hackers-win32(at)postgresql(dot)org>
  • Subject: Re: [GENERAL] Simple query takes a long time on win2K
  • Date: Wed, 23 Mar 2005 20:04:12 +0100
  • Message-id: <6BCB9D8A16AC4241919521715F4D8BCE6C713F(at)algol(dot)sollentuna(dot)se>

> > 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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group