> I'm wondering if anyone has tried running PgSQL on XP SP2?
> I have a problem with it - quite a big one. I have a perl DBI
> script which is a migration tool from old MySQL database
> format to a new PgSQL database. So here is a quick summary of
> the situation.
> MySQL (win32) - perl - PgSQL (Linux server) Runs fine, full
> speed, the script finishes its work in 20 minutes.
> Next, I move PgSQL to the windows side.
> MySQL (win32) - perl - PgSQL (win32, XP SP1) Runs fine, just
> a bit slower (like 25 minutes)
> In both previous cases there were 100% CPU load, HD
> activity, etc. - two databases raping poor windows XP workstation.
Are both MySQL and PgSQL Win32 on the same machine, or two different
> Next, after SP2 installation - that's here the fun comes. The
> process can take hours to complete. Actually, I never
> had a patience to see it finished - last time I aborted
> the process after 2 hours and the damn thing just finished
> about 50% of its job. I switched PgSQL back to Linux without
> changing anything else - no performance problems. I uninstalled
> SP2 and checked again - all is ok, all goes full speed, 25
> minutes for task completion. Reinstalled SP2 - and the
> problem came back. So for me it's quite obvious that SP2 has
> screwed up PgSQL in some way. I've tried several web
> forums, IRC - so far nobody seems to get into the same
> situation since I'm likely to be the only PgSQL user stupid
> enough to try SP2 :)
Is the machine still pegged at 100% CPU, or is the CPU idle? What about
> Now some details on what script does. It's, like I said, a
> migration script - it takes data from one database, changes
> it slightly and puts it to another one, using simple inserts.
> Nothing special. Although pg_restore seems to work just fine
> even under SP2, no performance problems.
Does your script run with just one connection, or does it open new
> There's more. I've tried PowerGres database as well. It
> experiences the same performance hit, no difference at all.
> Some details on the system - WinXP Pro, P4 2.4Ghz, 1GB RAM,
> 200GB SATA Seagate drive. I've disabled that firewall thingy
> and data execution prevention - again, nothing has changed.
> I'm out of ideas...
With disable firewall I assume you mean disable completely, and not just
set "postgres can do whatevever it wants"? If not, disable it completely
Are you running any antivirus on the machine? If so, try uninstalling
that too. I've seen AV products behave pretty differently on SP1 and
pgsql-hackers-win32 by date
|Next:||From: Maurizio Merli||Date: 2004-08-27 09:42:59|
|Subject: Ho can I implement C-Language function in Win32?|
|Previous:||From: Justin Wyer||Date: 2004-08-27 07:13:40|
|Subject: Re: 8.0 beta1 and XP SP2|