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?
-----Original Message-----
From: Magnus Hagander [mailto:mha@sollentuna.net]
Sent: March 23, 2005 4:43 AM
To: A. Mous; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Simple query takes a long time on win2K
> Hi,
>
> I have a table with about 1500 records. My query is very
> basic: SELECT * FROM foo;
>
> With postgres 8.0.1 on Win XP (Celeron 2400, 500MB RAM) it
> returns the results in about 80ms. The same query on the
> same database, tested on three different win2k machines all
> running 8.0.1, takes roughly 4 seconds. Win2K machines are
> as follows:
>
> 1) PIII 800, 256MB RAM
> 2) Celeron 400, 128MB RAM
> 3) PII 233, 128MB RAM
A Celeron 2400 is obviously much faster than any of these machines, no?
COmpared to the 200Mhz, you have 12 times the processor power.
This is fram frmo the difference you're seeing, though. But it might be
something like the server being able to complete a lot more work in a
single timeslice and thus decreasing context switching between
processes.
Is this Windows 2000 Server or Workstation? The difference in timeslice
lengths could make a difference here.
Do you see similar differences if you run it across the network?
//Magnus