Date: Mon, 30 Jun 2008 15:35:42 +0200
From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: Recommended RAID for Postgres
Message-ID: <20080630133542.GC24497@easy2.in-chemnitz.de>
References: <46F5921DF52F6E40860287B30CADADC79463A3@EROS.nexus-ag.com>
	<20080630125231.GB24497@easy2.in-chemnitz.de>
	<46F5921DF52F6E40860287B30CADADC79463C4@EROS.nexus-ag.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <46F5921DF52F6E40860287B30CADADC79463C4@EROS.nexus-ag.com>
User-Agent: Mutt/1.5.13 (2006-08-11)

On Mon, Jun 30, 2008 at 03:15:34PM +0200, Thomas Bräutigam wrote:

> Why avoid RAID5? I though that would be good? Can you explain this?

RAID5 has a lot of disadvantages, especially in terms of performance.
.oO(There was a link posted recently...)

> Writing in the DB, I add about 5-10 GB of data a day. There is a lot of writing activity going on in the database every day.
> What do you recommend how often I should backup the complete database?

What storage subsystem do you use? This sounds like you want something
like snapshots or similar to do backup. How long do you expect a 1-1.5
TB backup to run? I don't know. My biggest DBs are like 110 GB
(compressed dump), 300-400 GB on disk and they are difficult to handle
already.

Maybe other Postgres admins have more experience with such big DBs.

Tino.

-- 
"What we nourish flourishes." - "Was wir nähren erblüht."

www.craniosacralzentrum.de
www.forteego.de