Re: 8.0 beta1 and XP SP2

> -----Original Message-----
> From: pgsql-hackers-win32-owner@postgresql.org
> [mailto:pgsql-hackers-win32-owner@postgresql.org] On Behalf
> Of Magnus Hagander
> Sent: 27 August 2004 12:02
> To: oleg@ourmx.com; PgSQL Win32 developers
> Subject: Re: [pgsql-hackers-win32] 8.0 beta1 and XP SP2
>
> Can someone else confirm either that they also see a slowdown
> on SP2, or that they do *not*? Specifically when loading a
> bunch of data is best, but in general for "heavy load"
> situation would be enough.

This is *very* far from scientific, but, I tried loading the same
dumpfile on 2 systems:

Box 1:
Slackware Linux
Dual PIII 1GHz
15K RPM U160 SCSI Disk
1GB RAM
PostgreSQL 7.3.2 roughly tuned (yes, I know it needs upgrading)
6-8 other PostgreSQL users.
Load time: 24 seconds.

Box 2:
Windows XP Pro SP2
Centrino 2.7GHz
7200 RPM IDE disk (2.5")
1GB RAM
PostgreSQL 8.0 Dev out of the box
0 other users, but runnning various other apps.
Load time: 31 seconds.

I can't honestly say I've noticed any real slowdown since SP2 with the
exception of DNS lookups which are now dog slow, however, our ISP added
access controls to their servers at about the same time I upgraded so it
may be that.

Regards, Dave.