pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
8.0 beta1 and XP SP2
6+ messages / 3 participants
[nested] [flat]

* 8.0 beta1 and XP SP2
@ 2004-08-27 01:28  Oleg Letsinsky <oleg@ourmx.com>
  0 siblings, 3 replies; 6+ messages in thread

From: Oleg Letsinsky @ 2004-08-27 01:28 UTC (permalink / raw)
  To: PgSQL Win32 developers <pgsql-hackers-win32@postgresql.org>

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




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [pgsql-hackers-win32] 8.0 beta1 and XP SP2
@ 2004-08-27 07:10  Justin Wyer <justin@isogo.co.za>
  parent: Oleg Letsinsky <oleg@ourmx.com>
  2 siblings, 0 replies; 6+ messages in thread

From: Justin Wyer @ 2004-08-27 07:10 UTC (permalink / raw)
  To: pgsql-php

Oleg Letsinsky wrote:

>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 :)
>  
>
What is the CPU load under 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.
>  
>
If pg_restore works prehaps it is not a PostgreSQL problem....

>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...
>  
>
Try mod your script to dump back to the mysql database. Check if you get 
weird performance issues doing that.
I think assuming it is PostgreSQL at this point is jumping the gun. 
Maybe active states perl doesn't run so well on SP2, or it could even be 
mysql.

>Thanks for any input
>  
>
Pleasure

Regards
Justin



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: 8.0 beta1 and XP SP2
@ 2004-08-27 07:13  Justin Wyer <justin@isogo.co.za>
  parent: Oleg Letsinsky <oleg@ourmx.com>
  2 siblings, 1 reply; 6+ messages in thread

From: Justin Wyer @ 2004-08-27 07:13 UTC (permalink / raw)
  To: postgresql <pgsql-hackers-win32@postgresql.org>

Oleg Letsinsky wrote:

>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 :)
>  
>
What is the CPU load under 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.
>  
>
If pg_restore works prehaps it is not a PostgreSQL problem....

>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...
>  
>
Try mod your script to dump back to the mysql database. Check if you get
weird performance issues doing that.
I think assuming it is PostgreSQL at this point is jumping the gun.
Maybe active states perl doesn't run so well on SP2, or it could even be
mysql.

>Thanks for any input
>  
>
Pleasure

Regards
Justin




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: 8.0 beta1 and XP SP2
@ 2004-08-27 10:39  Oleg Letsinsky <oleg@ourmx.com>
  parent: Justin Wyer <justin@isogo.co.za>
  0 siblings, 0 replies; 6+ messages in thread

From: Oleg Letsinsky @ 2004-08-27 10:39 UTC (permalink / raw)
  To: postgresql <pgsql-hackers-win32@postgresql.org>

Hi Justin,

> Try mod your script to dump back to the mysql database. Check if you
> get weird performance issues doing that. I think assuming it is
> PostgreSQL at this point is jumping the gun. Maybe active states perl
> doesn't run so well on SP2, or it could even be mysql.

I've tried cygwin perl as well. But the point is that I need just to
change the PgSQL connection string in the script so it points to my linux
machine - and the performance is back. Please see my reply to Magnus, I
added some new info there as well.

--
  Oleg Letsinsky, 
  Software Developer




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: 8.0 beta1 and XP SP2
@ 2004-08-28 15:08  Ronald Kuczek <kuczek@kuczek.pl>
  parent: Oleg Letsinsky <oleg@ourmx.com>
  2 siblings, 1 reply; 6+ messages in thread

From: Ronald Kuczek @ 2004-08-28 15:08 UTC (permalink / raw)
  To: oleg@ourmx.com; +Cc: PgSQL Win32 developers <pgsql-hackers-win32@postgresql.org>

Użytkownik Oleg Letsinsky napisał:

>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 :)
>  
>
Hi Oleg,

Try this:

   1. Click *Start*, click *Run*, type sysdm.cpl, and then click *OK* to
      open Control Panel.
   2. Click the *Advanced *tab, click *Performance*, and then click
      *Settings*.
   3. In* Performance Options*, click the *Data Execution Prevention* tab.
   4. Click* Turn on DEP for all programs and services except for those
      I select*, and then click * Add*.
   5. In the *Open *dialog box, locate and then click the application.
   6. Click *Open*, click *Apply*, and then click *OK*. When you are
      prompted to restart your system, click *OK*.


Maybe there you'll find the solution:
http://support.microsoft.com/default.aspx?kbid=875351
http://support.microsoft.com/default.aspx?kbid=884130
http://support.microsoft.com/default.aspx?kbid=842242
http://support.microsoft.com/default.aspx?kbid=875357

I'll wait with SP2, it seems to be not really usable.

Best regards
Rony



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: 8.0 beta1 and XP SP2
@ 2004-08-28 16:52  Oleg Letsinsky <oleg@ourmx.com>
  parent: Ronald Kuczek <kuczek@kuczek.pl>
  0 siblings, 0 replies; 6+ messages in thread

From: Oleg Letsinsky @ 2004-08-28 16:52 UTC (permalink / raw)
  To: PgSQL Win32 developers <pgsql-hackers-win32@postgresql.org>

On Sat, Aug 28, 2004 at 05:08:50PM +0200, Ronald Kuczek wrote:
> 
> Hi Oleg,

Hi
> 
> Try this:
> 
>   1. Click *Start*, click *Run*, type sysdm.cpl, and then click *OK* to
>      open Control Panel.
>   2. Click the *Advanced *tab, click *Performance*, and then click
>      *Settings*.
>   3. In* Performance Options*, click the *Data Execution Prevention* tab.
>   4. Click* Turn on DEP for all programs and services except for those
>      I select*, and then click * Add*.
>   5. In the *Open *dialog box, locate and then click the application.
>   6. Click *Open*, click *Apply*, and then click *OK*. When you are
>      prompted to restart your system, click *OK*.

No, thanks. I've found the reason just yesterday (well, kind of) -
installed XP on a clean machine, applied SP2 and tested everything. No
problem. I just think that my installation is screwed - after just 3
months of existence. Damn... Like in haiku: "Yesterday it is working.
Today it is not. Windows is like that." I guess I'm too much of a wuss to
get into the trouble of reinstalling it again, so I'm back in Linux
totally.

Sorry for troubles, guys.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2004-08-28 16:52 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-27 01:28 8.0 beta1 and XP SP2 Oleg Letsinsky <oleg@ourmx.com>
2004-08-27 07:10 ` Justin Wyer <justin@isogo.co.za>
2004-08-27 07:13 ` Justin Wyer <justin@isogo.co.za>
2004-08-27 10:39   ` Oleg Letsinsky <oleg@ourmx.com>
2004-08-28 15:08 ` Ronald Kuczek <kuczek@kuczek.pl>
2004-08-28 16:52   ` Oleg Letsinsky <oleg@ourmx.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox