From: Rory Campbell-Lange <rory@campbell-lange.net>
To: August Zajonc <augustz@augustz.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: LVM and Postgres
Date: Tue, 6 Dec 2005 21:36:23 +0000
Message-ID: <20051206213623.GD14427@campbell-lange.net> (raw)
In-Reply-To: <dn4rb3$2d55$1@news.hub.org>
References: <20051206093818.GE6708@campbell-lange.net>
<dn4rb3$2d55$1@news.hub.org>
Hi August. Thanks very much for your mail.
On 06/12/05, August Zajonc (augustz@augustz.com) wrote:
> Rory Campbell-Lange wrote:
> >The server has a 250GB RAID10 (LSI 320-I + BBU) volume which I am
> >thinking of slicing up in the following way (Linux 2.6 kernel):
> >
> > / : ext3 : 47GB (root, home etc)
> > /boot : ext3 : 1GB
> > /tmp : ext2 : 2GB
> > /usr : ext3 : 4GB
> > /var : ext3 : 6GB
> > -----------------------
> > 60GB
> >
> > VG : 190GB approx
> > -----------------------
> > Initially divided so:
> > /data : ext3 : 90GB
> > /postgres : xfs : 40GB
> >
> >This gives me left over space of roughly 60GB to extend into on the
> >volume group, which I can balance between the /data and /postgres
> >logical volumes as needed.
>
> It looks like you are using fast disks and xfs for filesystem on the
> /postgresql partition. That's nice.
>
> How many disks in the array?
Four.
> One thing you miss is sticking a bunch of sequential log writes on a
> separate spindle as far as I can see with this? WAL / XFS (i think) both
> have this pattern. If you've got a fast disk and can do BBU write
> caching your WAL writes will hustle.
Yes, we don't have any spare disks unfortunately. We have enabled the
BBU write, so we are hoping for good performance. I'd be grateful for
some advice on dd/bonnie++ tests for checking this.
> Others can probably speak a bit better on any potential speedups.
I'd better test extending the Logical Volumes too!
Many thanks
Rory
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: rory@campbell-lange.net, augustz@augustz.com
Subject: Re: LVM and Postgres
In-Reply-To: <20051206213623.GD14427@campbell-lange.net>
* 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