Re: PostgreSQL7.1 on AIX5L is running with too poor ferformance - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: PostgreSQL7.1 on AIX5L is running with too poor ferformance
Date
Msg-id 20010730221807H.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: PostgreSQL7.1 on AIX5L is running with too poor ferformance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> "Leslie" <leslie@boreas.dti.ne.jp> writes:
> > PostgreSQL7.1 is now running on AIX5L( S85, 6GB memory, 6CPU), which was
> > running on Linux before(Pentium3, 2CPU, as far as I
> > remember.......sorry......).
> > The performance( on AIX5L ) is just half as good as the one( on Linux ).
> 
> Hmm ... is the AIX compilation selecting an appropriate TAS
> implementation for spinlocks? 

I think yes. I have compiled 7.1 on an AIX5L box and found that TAS()
was replaced by:
 cs((int *) (lock), 0, 1)

> If it's falling back to semaphore-based
> spinlocks, I can easily believe that you might take a 2X performance
> hit.  Possibly s_lock.h needs some additional #if tests for AIX5.
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Portal question
Next
From: Bruce Momjian
Date:
Subject: Re: Re: From TODO, XML?