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