Skip site navigation (1) Skip section navigation (2)

Re: 8.0 beta1 and XP SP2

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: <oleg(at)ourmx(dot)com>,"PgSQL Win32 developers" <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: 8.0 beta1 and XP SP2
Date: 2004-08-27 11:02:21
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE475B47@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
> > Are both MySQL and PgSQL Win32 on the same machine, or two 
> different 
> > machines?
> 
> They are on the same machine.

Ok. Grasping at some straws here, this could possiblyi be related to the
context switch storm reported on unix platforms. Can you check the
counter for context switches in perfmon? (It's under "System"). It
shouldn't be directly related since it's just one postgres backend, but
still. And compare this value to when running with SP1.


> > Is the machine still pegged at 100% CPU, or is the CPU idle? What 
> > about the I/O?
> 
> Sorry for not mentioning this before - after SP2 installation 
> CPU utilization has dropped almost to zero. Even task manager 
> consumes more CPU than both BD's. But the HD activity is 
> still quite high. I can send perfmon log for 
> CPU/Memory/Network/Physical Disk to anyone who interested. 5 
> phases: database setup through psql/idle time/my script works 
> for a couple of minutes/idle/database restored through pg_restore.
> Just 26 kb in bzip'ed form :)

Does the machine otherwise appear sluggish when doing things that are
I/O bound, or can you do things like copy a large file at about the same
speed as when idle? Simple way to check if the I/O system is saturated.
I don't see why that would change with SP2, but...


> > Does  your  script  run  with  just one connection, or does it open 
> > new connections often?
> 
> No, sure it creates DB connections on the start. TCPView 
> confirms this - no connection has been made since the start.

Ok. There goes that idea.


> >> 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
> > :-)
> 
> I even stopped and disabled the firewall service. Doesn't help much.

Ok. Try disabling the pgsql stats collector. Again, don't directly see
why it should have an effect, but if you're somehow getting lookup
problems for localhost or so.


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.


//Magnus


pgsql-hackers-win32 by date

Next:From: Dave PageDate: 2004-08-27 11:39:33
Subject: Re: 8.0 beta1 and XP SP2
Previous:From: Oleg LetsinskyDate: 2004-08-27 10:58:44
Subject: Re: 8.0 beta1 and XP SP2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group