Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance under contention - Mailing list pgsql-performance

From Robert Haas
Subject Re: Performance under contention
Date
Msg-id AANLkTinFqxaUnpq9E+oh6KcoyqPHDMxjS-_g3AJSPxmk@mail.gmail.com
Whole thread Raw
In response to Performance under contention  (Ivan Voras <ivoras@freebsd.org>)
Responses Re: Performance under contention  (Robert Haas <robertmhaas@gmail.com>)
Re: Performance under contention  (Jignesh Shah <jkshah@gmail.com>)
List pgsql-performance
Tree view 
On Sun, Nov 21, 2010 at 7:15 PM, Ivan Voras <ivoras@freebsd.org> wrote:
> The "sbwait" part is from FreeBSD - IPC sockets, but so much blocking on
> semwait indicates large contention in PostgreSQL.

I can reproduce this.  I suspect, but cannot yet prove, that this is
contention over the lock manager partition locks or the buffer mapping
locks.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-performance by date:

Previous
From: pasman pasmański
Date:
Subject: Strange optimization - xmin,xmax compression :)
Next
From: Tom Lane
Date:
Subject: Re: Group commit and commit delay/siblings