Re: PostgreSQL on multi-CPU systems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: darcy(at)druid(dot)net, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL on multi-CPU systems
Date: 2001-03-13 00:45:16
Message-ID: 8038.984444316@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Myers 2001-03-13 00:45:50 Re: WAL & SHM principles
Previous Message Tatsuo Ishii 2001-03-13 00:40:01 Re: PostgreSQL on multi-CPU systems