Re: PostgreSQL on multi-CPU systems - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostgreSQL on multi-CPU systems
Date
Msg-id 8038.984444316@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL on multi-CPU systems  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: PostgreSQL on multi-CPU systems  (darcy@druid.net (D'Arcy J.M. Cain))
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> I have tested PostgreSQL with 2-4 CPU linux boxes. In summary, 2 CPU
> was a big win, but 4 was not. I'm not sure where the bottle neck is
> though.

Our not-very-good implementation of spin locking (using select() to
wait) might have something to do with this.  Sometime soon I'd like to
look at using POSIX semaphores where available, instead of spinlocks.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: PostgreSQL on multi-CPU systems
Next
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: WAL & SHM principles