From: | Tino Schwarze <postgresql(at)tisc(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Recommended RAID for Postgres |
Date: | 2008-06-30 13:35:42 |
Message-ID: | 20080630133542.GC24497@easy2.in-chemnitz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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."
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-06-30 15:04:39 | Re: Windows xp initdb POSTGRES_SUPERUSERNAME |
Previous Message | Thomas Bräutigam | 2008-06-30 13:15:34 | Re: Recommended RAID for Postgres |