PostgreSQL performance scaling
luis.neves at gmail.com
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.
More information about the freebsd-performance