PostgreSQL performance scaling

Luis Neves luis.neves at gmail.com
Wed Nov 24 01:35:06 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"?
<http://pdos.csail.mit.edu/papers/linux:osdi10.pdf>


ABSTRACT.
"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-hackers mailing list