Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UKTYb-0004Qu-Oz for pgsql-performance@arkaria.postgresql.org; Tue, 26 Mar 2013 13:04:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UKTYb-0007F0-9r for pgsql-performance@arkaria.postgresql.org; Tue, 26 Mar 2013 13:04:53 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UKTYa-0007Dc-E4 for pgsql-performance@postgresql.org; Tue, 26 Mar 2013 13:04:52 +0000 Received: from host36.ns3.it ([80.79.54.36] helo=mail.opinioni.net) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UKTYT-0004zm-Gc for pgsql-performance@postgresql.org; Tue, 26 Mar 2013 13:04:51 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.opinioni.net (Postfix) with ESMTP id AD7195BF0E2 for ; Tue, 26 Mar 2013 14:06:07 +0100 (CET) Received: from mail.opinioni.net ([127.0.0.1]) by localhost (opinioni.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id q4sMYaM1gDyw for ; Tue, 26 Mar 2013 14:06:07 +0100 (CET) Received: from [192.168.1.50] (78-134-6-72.v4.ngi.it [78.134.6.72]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.opinioni.net (Postfix) with ESMTPS id 843CA5BF0E0 for ; Tue, 26 Mar 2013 14:06:07 +0100 (CET) Message-ID: <51519CE9.1070409@opinioni.net> Date: Tue, 26 Mar 2013 14:04:41 +0100 From: Andrea Suisani User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130308 Thunderbird/17.0.4 MIME-Version: 1.0 To: "pgsql-performance@postgresql.org" Subject: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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