Re: Simple query takes a long time on win2K

So, does this lend evidence to the theory that the difference is due to
insufficient RAM in all of the win2K pro machines?

-----Original Message-----
From: Magnus Hagander [mailto:mha(at)sollentuna(dot)net]
Sent: March 23, 2005 9:29 AM
To: A. Mous; pgsql-general(at)postgresql(dot)org
Subject: RE: [GENERAL] Simple query takes a long time on win2K

> You're right, the Celeron 2400 is much faster than the 200,
> but not that much more than the 1800, and all win2k
> (professional) machines are serving up the records in exactly
> the same amount of time.
>
> Across a network (issuing the query from the 2400 celeron win
> XP to the 233 PII win2k) the records are served up in about
> 300ms! Much faster than simply performing the exact same
> query locally on the PII.
>
> Now I'm really confused!
>
> Any ideas?

Yes, I suspect it has to do with context switching. When you run it
remotely the server can do it's job without much interference. When you
run the client on the same machine, it keeps flipping back and forth
between the server and the client.

You might get better performance on Win2k server, as that would increase
the timeslice for each piece of work. Also, try tweaking the
"Performance boost for foreground application" on the performance tab of
the system properties.

//Magnus