From: Frank Wiles <frank@wiles.org>
To: Juan Casero <caseroj@comcast.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Date: Sat, 24 Dec 2005 13:50:42 -0600
Message-ID: <20051224135042.484c6e32.frank@wiles.org> (raw)
In-Reply-To: <200512212231.55100.caseroj@comcast.net>
References: <43A84D03.7090002@ritek.hu>
<docq5v$24ea$1@news.hub.org>
<200512212209.50234.caseroj@comcast.net>
<200512212231.55100.caseroj@comcast.net>
On Wed, 21 Dec 2005 22:31:54 -0500
Juan Casero <caseroj@comcast.net> wrote:
> Sorry folks. I had a couple of glasses of wine as I wrote this.
> Anyway I originally wanted the box to have more than two drives so I
> could do RAID 5 but that is going to cost too much. Also, contrary
> to my statement below it seems to me I should run the 32 bit
> postgresql server on the 64 bit kernel. Would you agree this will
> probably yield the best performance? I know it depends alot on the
> system but for now this database is about 20 gigabytes. Not too large
> right now but it may grow 5x in the next year.
You definitely DO NOT want to do RAID 5 on a database server. That
is probably the worst setup you could have, I've seen it have lower
performance than just a single hard disk.
RAID 1 and RAID 1+0 are optimal, but you want to stay far away from
RAID 5. IMHO RAID 5 is only useful on near line backup servers or
Samba file servers where space is more important than speed.
---------------------------------
Frank Wiles <frank@wiles.org>
http://www.wiles.org
---------------------------------
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: frank@wiles.org, caseroj@comcast.net
Subject: Re: What's the best hardver for PostgreSQL 8.1?
In-Reply-To: <20051224135042.484c6e32.frank@wiles.org>
* 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