Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using a 250GB RAID10 server for postgres

Using a 250GB RAID10 server for postgres

From
Rory Campbell-Lange
Date:
[Didn't get any replies on the Perform list -- hoping someone can help
me here]

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

Re: Using a 250GB RAID10 server for postgres

From
Rory Campbell-Lange
Date:
In the absence of replies (and sorry to bombard the list), I should
clarify my question:

    Is it OK to use logical volume management to run an xfs partition
    hosting postgres data?

(The server specs are below.)

Thanks for any replies.

Rory

On 05/12/05, Rory Campbell-Lange (rory@campbell-lange.net) wrote:
> [Didn't get any replies on the Perform list -- hoping someone can help
> me here]
>
> 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
>
>

--
Rory Campbell-Lange
<rory@campbell-lange.net>
<www.campbell-lange.net>

Re: Using a 250GB RAID10 server for postgres

From
Bernhard Weisshuhn
Date:
On Tue, Dec 06, 2005 at 09:41:55AM +0000, Rory Campbell-Lange <rory@campbell-lange.net> wrote:

>     Is it OK to use logical volume management to run an xfs partition
>     hosting postgres data?

We use just that and it works splendid. It's very nice for adding space
and all that.

But I must admit that I haven't had any comments from the gurus wether
this is a wise choice performance wise.

Keep in mind that you might want devide your discs into two groups with
different physical discs so that you can make use of tablespaces. We use
them to seperate data and indexspace. Seperating the wal makes sense
only if there is nothing else accessing that disc.

just my two cents,
bkw