Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YfxXw-0005Tp-GI for pgsql-performance@arkaria.postgresql.org; Wed, 08 Apr 2015 21:30:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YfxXv-0002Av-VP for pgsql-performance@arkaria.postgresql.org; Wed, 08 Apr 2015 21:30:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YfxXv-0002An-3q for pgsql-performance@postgresql.org; Wed, 08 Apr 2015 21:30:03 +0000 Received: from mail-bl2on0707.outbound.protection.outlook.com ([2a01:111:f400:fc09::707] helo=na01-bl2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YfxXo-0007rc-1V for pgsql-performance@postgresql.org; Wed, 08 Apr 2015 21:30:01 +0000 Received: from BN1PR05MB009.namprd05.prod.outlook.com (10.255.202.141) by BN1PR05MB010.namprd05.prod.outlook.com (10.255.202.143) with Microsoft SMTP Server (TLS) id 15.1.130.23; Wed, 8 Apr 2015 21:29:49 +0000 Received: from BN1PR05MB009.namprd05.prod.outlook.com ([169.254.15.152]) by BN1PR05MB009.namprd05.prod.outlook.com ([169.254.15.152]) with mapi id 15.01.0130.020; Wed, 8 Apr 2015 21:29:49 +0000 From: Mel Llaguno To: Josh Berkus , =?iso-8859-2?Q?Przemys=B3aw_De=E6?= CC: "pgsql-performance@postgresql.org" Subject: Re: Some performance testing? Thread-Topic: [PERFORM] Some performance testing? Thread-Index: AQHQa+y0oLex6B2bWESYrFzIt6Alq502qcWAgAEsq4CACKi46IAA6QcAgAB0PND//6J3gIACBzkrgAAoMNs= Date: Wed, 8 Apr 2015 21:29:49 +0000 Message-ID: <1428528588777.75890@coverity.com> References: <551AFB01.50309@agliodbs.com> <5522F1DF.8090204@agliodbs.com> <552416D6.2040108@agliodbs.com> , <55257BEF.1010101@agliodbs.com> In-Reply-To: <55257BEF.1010101@agliodbs.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [184.70.198.10] authentication-results: postgresql.org; dkim=none (message not signed) header.d=none; x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BN1PR05MB010; x-forefront-antispam-report: BMV:1; SFV:NSPM; SFS:(10019020)(6009001)(164054003)(377454003)(24454002)(479174004)(19580395003)(99286002)(46102003)(122556002)(40100003)(86362001)(92566002)(87936001)(2656002)(2950100001)(66066001)(76176999)(54356999)(50986999)(2900100001)(36756003)(77156002)(62966003)(19580405001)(117636001)(93886004)(102836002)(106116001)(15975445007)(336755003)(18886065003); DIR:OUT; SFP:1102; SCL:1; SRVR:BN1PR05MB010; H:BN1PR05MB009.namprd05.prod.outlook.com; FPR:; SPF:None; MLV:sfv; LANG:en; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0; PCL:0; RULEID:(601004)(5002010)(5005006); SRVR:BN1PR05MB010; BCL:0; PCL:0; RULEID:; SRVR:BN1PR05MB010; x-forefront-prvs: 0540846A1D Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: coverity.com X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Apr 2015 21:29:49.0159 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 809a746c-a8df-4f37-86a4-bd3974a40f1e X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN1PR05MB010 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 Cool. Good to know. I'll see if I can replicate these results in my environ= ment. Thanks, M. ________________________________________ From: Josh Berkus Sent: Wednesday, April 08, 2015 1:05 PM To: Mel Llaguno; Przemys=B3aw De=E6 Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Some performance testing? On 04/07/2015 11:07 AM, Mel Llaguno wrote: > Care to elaborate? We usually do not recommend specific kernel versions > for our customers (who run on a variety of distributions). Thanks, M. You should. http://www.databasesoup.com/2014/09/why-you-need-to-avoid-linux-kernel-32.h= tml Performance is literally 2X to 5X different between kernels. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance