Re: Recommended RAID for Postgres

Hi Tino and Michael,

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.

I would like that a backup runs during the system is live, a snapshot would be okay. How long would a 1-1.5 TB backup run for this size of a Postgres DB? To bring the backup back after a crash again live, I would want a solution which takes me one or two days but not longer. Do you think I can reach the target with a snapshot and also keep in mind the size of the DB?

Cheers Thomas

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Tino Schwarze
Sent: Montag, 30. Juni 2008 15:36
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Recommended RAID for Postgres

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

--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin