Re: Recommended RAID for Postgres - Mailing list pgsql-admin

From Thomas Bräutigam
Subject Re: Recommended RAID for Postgres
Date
Msg-id 46F5921DF52F6E40860287B30CADADC79464D7@EROS.nexus-ag.com
Whole thread Raw
In response to Re: Recommended RAID for Postgres  (Tino Schwarze <postgresql@tisc.de>)
List pgsql-admin
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
doyou 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
diskand 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
runfor this size of a Postgres DB? To bring the backup back after a crash again live, I would want a solution which
takesme one or two days but not longer. Do you think I can reach the target with a snapshot and also keep in mind the
sizeof the DB? 

Cheers Thomas


-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tino Schwarze
Sent: Montag, 30. Juni 2008 15:36
To: pgsql-admin@postgresql.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
everyday. 
> 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
doyou 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
diskand 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@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



pgsql-admin by date:

Previous
From: adam_pgsql
Date:
Subject: Re: ask...!!!
Next
From: "M. Sederqvist"
Date:
Subject: PostgreSQL web administration