From: Rory Campbell-Lange <rory@campbell-lange.net>
To: pgsql-performance@postgresql.org
Subject: Dividing up a single 250GB RAID10 server for postgres
Date: Sun, 4 Dec 2005 23:49:34 +0000
Message-ID: <20051204234934.GA12887@campbell-lange.net> (raw)
Hi. We have a server provided for a test of a web application with the
following specifications:
1 Dual core 1.8GHz Opteron chip
6 GB RAM
approx 250GB of RAID10 storage (LSI card + BBU, 4 x 15000 RPM,16MB
Cache SCSI disks)
The database itself is very unlikely to use up more than 50GB of storage
-- however we are going to be storing pictures and movies etc etc on the
server.
I understand that it is better to run pg_xlog on a separate spindle but
we don't have that option available at present.
Normally I use ext3. I wondered if I should make my normal partitions
and then make a +/- 200GB LVM VG and then slice that initially into a
100GB ext3 data directory and a 50GB xfs postgres data area, giving
100GB to use between these as they grow. I haven't used LVM with xfs
before, however.
Advice gratefully received.
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
Subject: Re: Dividing up a single 250GB RAID10 server for postgres
In-Reply-To: <20051204234934.GA12887@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