Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TgO17-0008JV-20 for pgsql-performance@arkaria.postgresql.org; Wed, 05 Dec 2012 23:04:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TgO16-0006rg-2v for pgsql-performance@arkaria.postgresql.org; Wed, 05 Dec 2012 23:04:36 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TgO15-0006ra-3h for pgsql-performance@postgresql.org; Wed, 05 Dec 2012 23:04:35 +0000 Received: from smtp.optionshouse.com ([38.98.137.6] helo=smtp.peak6.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TgO11-00038O-8c for pgsql-performance@postgresql.org; Wed, 05 Dec 2012 23:04:33 +0000 X-AuditID: 0a64cb20-b7fe66d000002e97-14-50bfd2fd67b6 Message-ID: <50BFD2FC.3080802@optionshouse.com> Date: Wed, 5 Dec 2012 17:04:28 -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: Bruce Momjian CC: Daniel Farina , "pgsql-performance@postgresql.org" Subject: Re: Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance References: <50BF9247.2010800@optionshouse.com> <50BFC9D8.4010507@optionshouse.com> <20121205224148.GC30887@momjian.us> In-Reply-To: <20121205224148.GC30887@momjian.us> 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+NgFmpgleLIzCtJLcpLzFFi42LhSuGV0P17aX+AwcLJfBbXr2xit/i14RG7 xfWZ55gdmD2O3r3N5rGkuZPN48K+aewBzFENjDaJeXn5JYklqQopqcXJtkr+BSWZ+XnFHvml xakKLpnFyTmJmbmpRUoKmSm2SsZKCgU5icmpual5JbZKiQUFqXkpSnZcChjABqgsM08hNS85 PyUzL91WyTPYX9fCwtRS11DJLh4ZJHSyZNzf18NWsIOt4lz3KtYGxl7WLkZODgkBE4ll835C 2WISF+6tZwOxeQX0JXobtjGB2CwCKhLTGs6DxdkEdCUm9a8As4WA4n1nb4DV8AsIS+z70MQM YosKBEgsXnKOHWKOoMTJmU9YQGwRoPrjzzuBajg4mAXyJM5dCgYJCwv4S7x7cA5oJBfQyD2M ErfWbQS7h1PAQOL9hf9gvcwCthIX5lyHsuUltr+dwwxxg6rEiuaJbBD3K0j8v/KOaQKj0Cwk q2chaZ+FpH0BI/MqRvHissTkjEzTguLckgIjvYLUxGwzvbzUkk2M4Gg+rbCD8Xun1SFGAQ5G JR7eBd37A4RYE8uKK3MPMUpwMCuJ8JauAwrxpiRWVqUW5ccXleakFh9i9AGG2URmKdHkfGCi ySuJNzQ2NTC1NDU0NTc1NMIhrCTOGxq6KEBIIB2YSrJTUwtSi2DGMXFwSjUwTv8c+1pdv3AD x4ZjZi/jV8i3f85e4HytNK1X1f3ZQradc5Tkyhv4N897dUfh/4v9J2PVV+377HzLsi+q+Mvj s5JNEWzPP1RtMFaoLp24YvePrbtOZe09Y9bsPOlMR9aiN3bvOJ1mZBocvmj+JlPvhuhpz+ZV r7bFed11d390LnDT8QOa5mKWz5VYijMSDbWYi4oTAYdVcU0TAwAA 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 12/05/2012 04:41 PM, Bruce Momjian wrote: > Ah, that is interesting about 2.6. I had wondered how Debian stable > would have performed, 2.6.32-5. This relates to a recent discussion > about the appropriateness of Ubuntu for database servers: Hmm. I may have to recant. I just removed our fusionIO driver from the loop and suddenly everything is honey and roses. It would appear that some recent 3.2 kernel patch borks the driver in some horrible way. Wihtout it, I see 50-ish percent CPU, 70k tps even with 800 clients... Just like 3.4. So I jumped the gun a bit. Stupid drivers. I'm still curious why only recent 3.2's cause it, but 3.4 don't. That's mighty odd. -- 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