From: Jan de Visser <jdevisser@digitalfairway.com>
To: pgsql-performance@postgresql.org
Subject: Re: Performance Issues on Opteron Dual Core
Date: Wed, 3 May 2006 08:30:10 -0400
User-Agent: KMail/1.9.1
References: <6BCB9D8A16AC4241919521715F4D8BCEA0F957@algol.sollentuna.se>
In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCEA0F957@algol.sollentuna.se>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200605030830.10364.jdevisser@digitalfairway.com>

On Wednesday 03 May 2006 03:29, Magnus Hagander wrote:
> > > > FWIW, I've found problems running PostgreSQL on Windows in a
> > > > multi-CPU environment on w2k3. It runs fine for some period, and
> > > > then CPU and throughput drop to zero. So far I've been unable to
> > > > track down any more information than that, other than the
> >
> > fact that
> >
> > > > I haven't been able to reproduce this on any single-CPU machines.
> > >
> > > I have had previous correspondence about this with Magnus (search
> > > -general and -hackers). If you uninstall SP1 the problem
> >
> > goes away. We
> >
> > > played a bit with potential fixes but didn't find any.
> >
> > Interesting; does SP2 fix the problem? Anything we can do
> > over here to help?
>
> There is no SP2 for Windows 2003.

That's what I thought. Jim confused me there for a minute.

>
> Have you tried this with latest-and-greatest CVS HEAD? Meaning with the
> new semaphore code that was committed a couple of days ago?

No I haven't. Worth a test on a rainy afternoon I'd say...

>
> //Magnus

jan

=2D-=20
=2D-------------------------------------------------------------
Jan de Visser =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 jdevisser@digitalfair=
way.com

=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Baruk Khazad! Khazad ai-menu!
=2D-------------------------------------------------------------