Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: Re: Recommended RAID for Postgres
Date: Tue, 1 Jul 2008 13:50:10 +0200
Message-ID: <46F5921DF52F6E40860287B30CADADC79464D7@EROS.nexus-ag.com>
In-Reply-To: <20080630133542.GC24497@easy2.in-chemnitz.de>
Thread-Topic: [ADMIN] Recommended RAID for Postgres
Thread-Index: AcjauWL1/XCAB079Tp2SNYO62Px7gQAtrmqA
References: <46F5921DF52F6E40860287B30CADADC79463A3@EROS.nexus-ag.com>
	<20080630125231.GB24497@easy2.in-chemnitz.de>
	<46F5921DF52F6E40860287B30CADADC79463C4@EROS.nexus-ag.com>
	<20080630133542.GC24497@easy2.in-chemnitz.de>
From: =?iso-8859-1?Q?Thomas_Br=E4utigam?= <thomas.braeutigam@nexustelecom.com>
To: "Tino Schwarze" <postgresql@tisc.de>, <pgsql-admin@postgresql.org>,
	<michael.monnerie@it-management.at>

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@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=E4utigam 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=E4hren erbl=FCht."

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