PostgreSQL performance scaling

Luis Neves luis.neves at
Wed Nov 24 01:40:07 UTC 2010

On 11/22/2010 12:21 AM, Ivan Voras wrote:

> The "semwait" part is from PostgreSQL - probably shared buffer locking,
> but there's a large number of processes regularly in sbwait - maybe
> something can be optimized here?

I think this paper was mentioned before, did you read it?... "An 
Analysis of Linux Scalability to Many Cores"?

"This paper analyzes the scalability of seven system applications (Exim,
memcached, Apache, PostgreSQL, gmake, Psearchy, and MapReduce) running
on Linux on a 48- core computer."

The paper is about Linux, but it also focus on some changes that can be 
made to PostgreSQL to achieve better concurrency.

Luis Neves

More information about the freebsd-performance mailing list