Re: PostgreSQL performance scaling

[ Available lists | Index of freebsd-performance | Month of Nov 2010 | Week of 24 Nov 2010 | Raw email | View thread | Wrap long lines | Reply | Tag ]
From
Luis Neves <luis.neves@gmail.com>
Date
24 Nov 2010 01:40:07
Subject
Re: PostgreSQL performance scaling
Message-ID
ichpqp$vr8$1@dough.gmane.org

In reply to
References to

[ Hide this part ]
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


Elapsed time: 0.132 seconds