Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TtKRg-0007xT-UJ for pgsql-performance@arkaria.postgresql.org; Thu, 10 Jan 2013 15:53:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TtKRf-0005TW-Ex for pgsql-performance@arkaria.postgresql.org; Thu, 10 Jan 2013 15:53:31 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TtKRe-0005TR-Kt for pgsql-performance@postgresql.org; Thu, 10 Jan 2013 15:53:30 +0000 Received: from smtp.peak6.com ([38.98.137.6]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TtKRb-0001ov-OF for pgsql-performance@postgresql.org; Thu, 10 Jan 2013 15:53:28 +0000 X-AuditID: 0a64cb20-b7f466d0000073cd-59-50eee3f6c4bd Message-ID: <50EEE3F5.7070405@optionshouse.com> Date: Thu, 10 Jan 2013 09:53: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: Henri Philipps CC: Subject: Re: Two Necessary Kernel Tweaks for Linux Systems References: <50E4AAB1.9040902@optionshouse.com> <50EC6549.3090503@optionshouse.com> <50EC6742.4090303@optionshouse.com> <50EC743E.1040209@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+NgFvrOIsWRmVeSWpSXmKPExsXClcIrofvt8bsAg2UdMhYz/21nt7g+8xyz A5PHzll32T0u7JvGHsAU1cBok5iXl1+SWJKqkJJanGyr5F9QkpmfV+yRX1qcquCSWZyck5iZ m1qkpJCZYqtkrKRQkJOYnJqbmldiq5RYUJCal6Jkx6WAAWyAyjLzFFLzkvNTMvPSbZU8g/11 LSxMLXUNlezikUFCJ0vG/puN7AUbuSo6Hixgb2Bcx9HFyMkhIWAi8XneFHYIW0ziwr31bCA2 r4C+xNGV78HiLAKqEhdX/2UCsdkEdCUm9a8AqxESUJHoO3sDLM4vICyx70MTM4gtKhAgsXjJ OXaIOYISJ2c+YQGxRYB69044AlbPLKAmMffhJFYQW1jAReJa0yqgmVxAM6cyS2y7/QcswSkQ KDHp22dmiAZbiQtzrrNA2PIS29/OYYY4QlViRfNENogHFCT+X3nHNIFRaBaS3bOQtM9C0r6A kXkVo3hxWWJyRqZpQXFuSYGRXkFqYraZXl5qySZGcOyeVtjB+L3T6hCjAAejEg/vg4h3AUKs iWXFlbmHGCU4mJVEeFsWAIV4UxIrq1KL8uOLSnNSiw8x+gADbSKzlGhyPjCt5JXEGxqbGpha mhqampsaGuEQVhLnvVHzNkBIIB2YTLJTUwtSi2DGMXFwSjUwJlpqPj94ae8Lts7fhr8nMB/o PBIYqc3XEfK4z/NZdmqE67mQU7NVBKqfhd9atvb87S/+MSoxMcobTU8bMDq8+v7wEEMa02up jwk/P7ZOF5VoV/n6OlU35e/vcrX6678Y/fY6LPrubbS4Vvv2VNlDa2wXX3cOfbKigj+jLXhl 187DZkK/ArMTlFiKMxINtZiLihMBB1nHXAoDAAA= 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/10/2013 02:51 AM, Henri Philipps wrote: > http://research.cs.wisc.edu/adsl/Publications/meehean-thesis11.pdf Wow, that was pretty interesting. It looks like for servers, the O(1) scheduler is much better even with the assignment bug he identified, and BFS responds better to varying load than CFS. It's too bad the paper is so old and only considers the 2.6 kernel. I'd love to see this type of research applied to the latest. > sched_latency_ns > sched_min_granularity_ns > > I guess that higher numbers could improve performance too on systems > with many cores and many connections. I messed around with these a bit. Settings 10x smaller and 10x larger didn't do anything appreciable that I noticed. Performance metrics were within variance of my earlier tests. Only autogrouping and migration cost had any appreciable effect. I'm glad we weren't the only ones who ran into this, too. You settled on a much higher setting than we did, but the end result was the same. I wonder how prevalent this will become as more servers are switched over to newer kernels in the next couple of years. Hopefully more people start complaining so they fix it. :) -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-676-8870 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