From: Scott Carey <scott@richrelevance.com>
To: Alan Hodgson <ahodgson@simkin.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: Effects of setting linux block device readahead size
Date: Thu, 11 Sep 2008 16:20:19 -0700
Message-ID: <a1ec7d000809111620h56ea61dche3dae68d1df2a3f6@mail.gmail.com> (raw)
In-Reply-To: <200809111541.55525@hal.medialogik.com>
References: <70c01d1d0809092353r4ae687a3ycf3d99d43a5680cf@mail.gmail.com>
<dcc563d10809111440q414c5285j5bff925fad310b41@mail.gmail.com>
<alpine.DEB.1.10.0809111529120.15169@asgard.lang.hm>
<200809111541.55525@hal.medialogik.com>
I also thought that LVM is unsafe for WAL logs and file system journals with
disk write cache -- it doesn't flush the disk write caches correctly and
build write barriers.
As pointed out here:
http://groups.google.com/group/pgsql.performance/browse_thread/thread/9dc43991c1887129
by Greg Smith
http://lwn.net/Articles/283161/
On Thu, Sep 11, 2008 at 3:41 PM, Alan Hodgson <ahodgson@simkin.ca> wrote:
> On Thursday 11 September 2008, david@lang.hm wrote:
> > while I agree with you in theory, in practice I've seen multiple
> > partitions cause far more problems than they have prevented (due to the
> > partitions ending up not being large enough and having to be resized
> > after they fill up, etc) so I tend to go in the direction of a few large
> > partitions.
>
> I used to feel this way until LVM became usable. LVM plus online resizable
> filesystems really makes multiple partitions manageable.
>
>
> --
> Alan
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
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: scott@richrelevance.com, ahodgson@simkin.ca
Subject: Re: Effects of setting linux block device readahead size
In-Reply-To: <a1ec7d000809111620h56ea61dche3dae68d1df2a3f6@mail.gmail.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