> 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