From: Sven Geisler <sgeisler@aeccom.com>
To: hubert depesz lubaczewski <depesz@gmail.com>
Cc: Pgsql-Performance <pgsql-performance@postgresql.org>
Subject: Re: how to partition disks
Date: Wed, 14 Jun 2006 10:26:43 +0200
Message-ID: <448FC843.1090205@aeccom.com> (raw)
In-Reply-To: <9e4684ce0606140052m62552d41xa9364b9d4e266c97@mail.gmail.com>
References: <9e4684ce0606140052m62552d41xa9364b9d4e266c97@mail.gmail.com>
Hi Hubert,
hubert depesz lubaczewski schrieb:
> hi
> i'm waiting for new server to arrive.
> for the server i will get hp msa1000, with 14 discs (72g, 15000 rpm).
> what kind of partitioning you suggest, to get maximum performance?
> for system things i will have separate discs, so whole array is only for
> postgresql.
>
> data processing is oltp, but with large amounts of write operations.
>
> any hints?
>
> should i go with 3 partitions, or just 1? or 2?
>
You should configure your discs to RAID 10 volumes.
You should set up a separate volume for WAL.
A volume for an additional table space may also useful.
In your case I would do 2 partitions:
1. RAID 10 with 8 discs for general data
2. RAID 10 with 4 discs for WAL
(two disk as spare)
You may split the first volume in two volumes for a second table space
if you Server doesn't have enough RAM and you have a high disk read I/O.
Cheers
Sven.
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: sgeisler@aeccom.com, depesz@gmail.com
Subject: Re: how to partition disks
In-Reply-To: <448FC843.1090205@aeccom.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