> -----Original Message-----
> From: pgsql-hackers-win32-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf
> Of Magnus Hagander
> Sent: 27 August 2004 12:02
> To: oleg(at)ourmx(dot)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:
Dual PIII 1GHz
15K RPM U160 SCSI Disk
PostgreSQL 7.3.2 roughly tuned (yes, I know it needs upgrading)
6-8 other PostgreSQL users.
Load time: 24 seconds.
Windows XP Pro SP2
7200 RPM IDE disk (2.5")
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.
pgsql-hackers-win32 by date
|Next:||From: Merlin Moncure||Date: 2004-08-27 12:26:18|
|Subject: Re: How can I implement a Win32 C-Language function?|
|Previous:||From: Magnus Hagander||Date: 2004-08-27 11:02:21|
|Subject: Re: 8.0 beta1 and XP SP2|