Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id C05E71E62E80 for ; Wed, 25 Apr 2012 04:46:24 -0300 (ADT) Received: from out1.ip05ir2.opaltelecom.net ([62.24.128.241]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SMwvc-0000Bd-4l for pgsql-performance@postgresql.org; Wed, 25 Apr 2012 07:46:22 +0000 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApMBAOmql09PS0HE/2dsb2JhbAANN7RhAQEBAQM4ES8BEAsYCRYPCQMCAQIBRRMBBwEBwyuNUoMlBKki X-IronPort-AV: E=Sophos;i="4.75,480,1330905600"; d="scan'208";a="378702158" Received: from 79-75-65-196.dynamic.dsl.as9105.com (HELO [192.168.6.20]) ([79.75.65.196]) by out1.ip05ir2.opaltelecom.net with ESMTP; 25 Apr 2012 08:46:03 +0100 Message-ID: <4F97ABBB.1000708@kickstone.co.uk> Date: Wed, 25 Apr 2012 08:46:03 +0100 From: John Lister Organization: Kickstone Technologies Ltd User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20120327 Thunderbird/11.0.1 MIME-Version: 1.0 To: sthomas@peak6.com CC: pgsql-performance@postgresql.org Subject: Re: Configuration Recommendations References: <4F96FFE1.2030809@peak6.com> In-Reply-To: <4F96FFE1.2030809@peak6.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.2 (-) X-Archive-Number: 201204/160 X-Sequence-Number: 46806 On 24/04/2012 20:32, Shaun Thomas wrote: > > I'm not sure if you've done metrics or not, but XFS performance is > highly dependent on your init and mount options. I can give you some > guidelines there, but one of the major changes is that the Linux 3.X > kernels have some impressive performance improvements you won't see > using CentOS 6.2. Metadata in particular has undergone a massive > upgrade that drastically enhances its parallel scalability on metadata > modifications. Hi, I'd be grateful if you could share any XFS performance tweaks as I'm not entirely sure I'm getting the most out of my setup and any additional guidance would be very helpful. Thanks John -- www.pricegoblin.co.uk