Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCFKY-0007t3-QM for pgsql-performance@arkaria.postgresql.org; Sun, 03 Mar 2013 20:16:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UCFKY-0003Rn-5o for pgsql-performance@arkaria.postgresql.org; Sun, 03 Mar 2013 20:16:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCFKX-0003Ri-Fk for pgsql-performance@postgresql.org; Sun, 03 Mar 2013 20:16:21 +0000 Received: from outmail148150.authsmtp.net ([62.13.148.150]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCFKS-0001Gx-LS for pgsql-performance@postgresql.org; Sun, 03 Mar 2013 20:16:21 +0000 Received: from mail-c226.authsmtp.com (mail-c226.authsmtp.com [62.13.128.226]) by punt7.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id r23KGBC2028878; Sun, 3 Mar 2013 20:16:11 GMT Received: from [192.168.47.109] (50-0-92-178.dsl.dynamic.sonic.net [50.0.92.178]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/) with ESMTP id r23KG8Q4077405; Sun, 3 Mar 2013 20:16:09 GMT Message-ID: <5133AF87.9040704@agliodbs.com> Date: Sun, 03 Mar 2013 12:16:07 -0800 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130106 Thunderbird/17.0.2 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: hardware upgrade, performance degrade? References: In-Reply-To: X-Enigmail-Version: 1.5.1 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: 301aa589-843f-11e2-98a9-0025907ec6c5 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQL c1ACdR12OUdbHwkA AHYJW15VVldxUC1w axRRcwxffEtJVxpo U1dJDBBQF34fCX0F BhkZVhl3OQZGeXw+ ZkZjDyFeVE1nfUJ+ FFNVFDgEeG5oOWkC UEBacgpUd1YZeExA JDIqXmNmARBlEAUC Ojp7PzkrMSpWMikd XxkCN1seTAJDBjMm SRcYGDwpFkBNSyg8 NRUqJwl0 X-Authentic-SMTP: 61633136333939.1020:706 X-AuthFastPath: 0 (Was 255) X-AuthSMTP-Origin: 50.0.92.178/23 X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Pg-Spam-Score: -2.6 (--) 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 Steven, > We saw the same performance problems when this new hardware was running > cent 6.3 with a 2.6.32-279.19.1.el6.x86_64 kernel and when it was matched > to the OS/kernel of the old hardware which was cent 5.8 with > a 2.6.18-308.11.1.el5 kernel. Oh, now that's interesting. We've been seeing the same issue (IO stalls on COMMIT) ond had attributed it to some bugs in the 3.2 and 3.4 kernels, partly because we don't have a credible "old server" to test against. Now you have me wondering if there's not a hardware or driver issue with a major HW manufacturer which just happens to be hitting around now. Can you detail your hardware stack so that we can compare notes? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance