pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrea Suisani <sickpig@opinioni.net>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability
Date: Tue, 26 Mar 2013 14:04:41 +0100
Message-ID: <51519CE9.1070409@opinioni.net> (raw)
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

Hi all,

Just to let the community know that probably Linux kernel 3.10
will include some work to make sysv semaphore code more scalable.
Since Postgres use this kernel features I've thought to post it
here just for the sake of sharing a good news:

The thread where Rik van Riel posts the v3 patch series:

http://thread.gmane.org/gmane.linux.kernel/1460761

Here http://thread.gmane.org/gmane.linux.kernel/1460761/focus=1461794
Davidlohr Bueso (patches co-author) post an interesting results
comparing multiple runs of "[his] Oracle Swingbench DSS" workload.
Reported here for brevity:

TPS:
100 users: 1257.21 (vanilla)    2805.06 (v3 patchset)
400 users: 1437.57 (vanilla)    2664.67 (v3 patchset)
800 users: 1236.89 (vanilla)    2750.73 (v3 patchset)

ipc lock contention:
100 users:  8,74%  (vanilla)    3.17% (v3 patchset)
400 users:  21,86% (vanilla)    5.23% (v3 patchset)
800 users   84,35% (vanilla)    7.39% (v3 patchset)

as soon as I've a spare server to play with and a little
of time I will give it a spin.

Andrea







-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (4+ messages)  latest in thread

Message-ID: <51519CE9.1070409@opinioni.net>
Permalink:  ../51519CE9.1070409@opinioni.net/
Also on:    postgresql.org/message-id/51519CE9.1070409@opinioni.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sickpig@opinioni.net
  Subject: Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability
  In-Reply-To: <51519CE9.1070409@opinioni.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox