Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tsdub-00066U-HW for pgsql-performance@arkaria.postgresql.org; Tue, 08 Jan 2013 18:28:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tsdub-0000R1-2P for pgsql-performance@arkaria.postgresql.org; Tue, 08 Jan 2013 18:28:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tsdua-0000Qw-Bv for pgsql-performance@postgresql.org; Tue, 08 Jan 2013 18:28:32 +0000 Received: from smtp2.peak6.com ([38.98.137.9]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TsduW-0002Oo-9u for pgsql-performance@postgresql.org; Tue, 08 Jan 2013 18:28:32 +0000 X-AuditID: 0a02cb20-b7fa76d000004170-23-50ec654995f0 Received: from sswchi5pcas2.peak6.net (sswchi5pcas2.peak6.net [10.100.13.24]) by smtp2.peak6.com (Symantec Messaging Gateway) with SMTP id C9.AA.16752.9456CE05; Tue, 8 Jan 2013 12:28:26 -0600 (CST) Received: from [10.10.201.64] (10.10.201.64) by sswchi5pcas2.peak6.net (10.100.13.25) with Microsoft SMTP Server (TLS) id 14.2.247.3; Tue, 8 Jan 2013 12:28:25 -0600 Message-ID: <50EC6549.3090503@optionshouse.com> Date: Tue, 8 Jan 2013 12:28:25 -0600 From: Shaun Thomas Reply-To: Organization: Peak6 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/17.0 Thunderbird/17.0 MIME-Version: 1.0 To: Midge Brown CC: Subject: Re: Two Necessary Kernel Tweaks for Linux Systems References: <50E4AAB1.9040902@optionshouse.com> In-Reply-To: Content-Type: text/plain; charset="ISO-8859-1"; format=flowed content-transfer-encoding: 7bit X-Originating-IP: [10.10.201.64] X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFupnleLIzCtJLcpLzFFi42LhSuGV0PVKfRNgcHoDu8WyX1YW12eeY3Zg 8riwbxq7x/r/i1kDmKIaGG0S8/LySxJLUhVSUouTbZX8C0oy8/OKPfJLi1MVXDKLk3MSM3NT i5QUMlNslYyVFApyEpNTc1PzSmyVEgsKUvNSlOy4FDCADVBZZp5Cal5yfkpmXrqtkmewv66F hamlrqGSXTwySOhkyfh5YQ5zwW7Wir2rFjE2MK5j6WLk5JAQMJE4cfUGlC0mceHeerYuRi4O IYETjBLbFs2FclYwSlzsvwpWxSugL3FpzlUmEJtFQEVi+drFbCA2m4CuxKT+FWC2EFC87+wN sBp+AWGJfR+amEFsUYEAicVLzrFDzBGUODnzCdhMEQF1icm7/oDVMwuoScx9OIkVxBYWcJG4 1rQKamaUxK+WZjCbU8Bc4v2NA1D1thIX5lxngbDlJba/ncMMUa8qsaJ5IhvEZwoS/6+8Y5rA KDILyepZSNpnIWlfwMi8ilG8uCwxOSPTrKA4t6TASK8gNTHbTC8vtWQTIyjWmU4r7GDc3GN1 iFGAg1GJh7ch8XWAEGtiWXFl7iFGCQ5mJRHeu95vAoR4UxIrq1KL8uOLSnNSiw8x+gDDbCKz lGhyPjAN5ZXEGxqbGphamhqampsaGuEQVhLnDQ1dFCAkkA5MP9mpqQWpRTDjmDg4pRoYK66e +zIrSDzuXpRVR9Pe11eYqst8HlZ2ch50PrPiRF0G14yy96uy6wJag3ZUvTilZe7oyaxaVvM2 a8l/g3OzJ99dfPeju2VFlFmgy9vz9sfy72nKlO3QevWV98dcUanVOzQO11wUmC4hGn1j09Qf 4tLJKzdPW3d4IYtQ/VPf/ztVf68/IFX5U4mlOCPRUIu5qDgRAClawUciAwAA 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 On 01/08/2013 12:25 PM, Midge Brown wrote: > The kernel on our Linux system doesn't appear to have these two > settings according to the list provided by sysctl -a. Please pardon > my ignorance, but should I add them? Sorry if I wasn't more clear. These only apply to Linux systems with the Completely Fair Scheduler, as opposed to the O(1) scheduler. For all intents and purposes, this means 3.0 kernels and above. With a 2.6 kernel, you're fine. Effectively these changes fix what is basically a performance regression compared to older kernels. -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-444-8534 sthomas@optionshouse.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance