8.0 beta1 and XP SP2
От | Oleg Letsinsky |
---|---|
Тема | 8.0 beta1 and XP SP2 |
Дата | |
Msg-id | 1677078158.20040827052820@ourmx.com обсуждение исходный текст |
Ответы |
Re: 8.0 beta1 and XP SP2
Re: 8.0 beta1 and XP SP2 |
Список | pgsql-hackers-win32 |
Hi, 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. 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 :) 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. 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... Thanks for any input -- Oleg Letsinsky, Software Developer
В списке pgsql-hackers-win32 по дате отправления: