Re: Configuration Recommendations - Mailing list pgsql-performance

From John Lister
Subject Re: Configuration Recommendations
Date
Msg-id 4F97ABBB.1000708@kickstone.co.uk
Whole thread Raw
In response to Re: Configuration Recommendations  (Shaun Thomas <sthomas@peak6.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Richard Kojedzinszky
Date:
Subject: query optimization
Next
From: Claudio Freire
Date:
Subject: Re: Weird plan variation with recursive CTEs