From: Greg Smith <greg@2ndquadrant.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Scott Carey <scott@richrelevance.com>
Cc: Kenneth Cox <kenstir@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Advice configuring ServeRAID 8k for performance
Date: Tue, 17 Aug 2010 04:42:25 -0400
Message-ID: <4C6A4B71.5040909@2ndquadrant.com> (raw)
In-Reply-To: <201008170131.o7H1VPc26427@momjian.us>
References: <201008170131.o7H1VPc26427@momjian.us>
Bruce Momjian wrote:
> Scott Carey wrote:
>
>> Don't ever have WAL and data on the same OS volume as ext3.
>>
>> ...
>> One partition for WAL, one for data. If using ext3 this is essentially
>> a performance requirement no matter how your array is set up underneath.
>>
>
> Do we need to document this?
>
Not for 9.0. What Scott is suggesting is often the case, but not
always; I can produce a counter example at will now that I know exactly
which closets have the skeletons in them. The underlying situation is
more complicated due to some limitations to the whole "spread
checkpoint" code that is turning really sour on newer hardware with
large amounts of RAM. I have about 5 pages of written notes on this
specific issue so far, and that keeps growing every week. That's all
leading toward a proposed 9.1 change to the specific fsync behavior.
And I expect to dump a large stack of documentation to support that
patch that will address this whole area. I'll put the whole thing onto
the wiki as soon as my 9.0 related work settles down.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndquadrant.com, bruce@momjian.us, scott@richrelevance.com, kenstir@gmail.com
Subject: Re: Advice configuring ServeRAID 8k for performance
In-Reply-To: <4C6A4B71.5040909@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox