From: mudfoot@rawbw.com
To: pgsql-performance@postgresql.org
Subject: Re: Multiple disks: RAID 5 or PG Cluster
Date: Fri, 17 Jun 2005 13:38:41 -0700
Message-ID: <1119040721.42b334d1c3ec9@webmail.rawbw.com> (raw)
In-Reply-To: <7a1914222f313b7c5e88bedb8a662f12@implements.be>
References: <7a1914222f313b7c5e88bedb8a662f12@implements.be>
If you truly do not care about data protection -- either from drive loss or from
sudden power failure, or anything else -- and just want to get the fastest
possible performance, then do RAID 0 (striping). It may be faster to do that
with software RAID on the host than with a special RAID controller. And turn
off fsyncing the write ahead log in postgresql.conf (fsync = false).
But be prepared to replace your whole database from scratch (or backup or
whatever) if you lose a single hard drive. And if you have a sudden power loss
or other type of unclean system shutdown (kernel panic or something) then your
data integrity will be at risk as well.
To squeeze evena little bit more performance, put your operating system, swap
and PostgreSQL binaries on a cheap IDE or SATA drive--and only your data on the
5 striped SCSI drives.
I do not know what clustering would do for you. But striping will provide a
high level of assurance that each of your hard drives will process equivalent
amounts of IO operations.
Quoting Yves Vindevogel <yves.vindevogel@implements.be>:
> Hi,
>
> We are looking to build a new machine for a big PG database.
> We were wondering if a machine with 5 scsi-disks would perform better
> if we use a hardware raid 5 controller or if we would go for the
> clustering in PG.
> If we cluster in PG, do we have redundancy on the data like in a RAID 5
> ?
>
> First concern is performance, not redundancy (we can do that a
> different way because all data comes from upload files)
>
> Met vriendelijke groeten,
> Bien à vous,
> Kind regards,
>
> Yves Vindevogel
> Implements
>
>
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: mudfoot@rawbw.com
Subject: Re: Multiple disks: RAID 5 or PG Cluster
In-Reply-To: <1119040721.42b334d1c3ec9@webmail.rawbw.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