[OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability - Mailing list pgsql-performance

From Andrea Suisani
Subject [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability
Date
Msg-id 51519CE9.1070409@opinioni.net
Whole thread Raw
Responses Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability
List pgsql-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







pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: 9.2.3 upgrade reduced pgbench performance by 60%
Next
From: Shaun Thomas
Date:
Subject: Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability