From: Montaseri <montaseri@gmail.com>
To: Mikko Partio <mpartio@gmail.com>
Cc: Thomas Bräutigam <thomas.braeutigam@nexustelecom.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Recommended RAID for Postgres
Date: Tue, 8 Jul 2008 11:12:12 -0700
Message-ID: <8078a1730807081112j6d49512kd1f738eb64ae20b0@mail.gmail.com> (raw)
In-Reply-To: <2ca799770807070128l2498e9c3pe5d9e469d0dc8269@mail.gmail.com>
References: <46F5921DF52F6E40860287B30CADADC79463A3@EROS.nexus-ag.com>
<2ca799770807070128l2498e9c3pe5d9e469d0dc8269@mail.gmail.com>
I'd also vote for RAID-5, best disk utilization, good on read, bad on
writes, performance is good due to stripping
If you can get some hardware raid to do the job (vs software raid) than
performance gets better...an HBA board as low as $150 will (at least) double
your speed
Medi
On Mon, Jul 7, 2008 at 1:28 AM, Mikko Partio <mpartio@gmail.com> wrote:
>
>
> On Mon, Jun 30, 2008 at 3:30 PM, Thomas Bräutigam <
> thomas.braeutigam@nexustelecom.com> wrote:
>
>> Hello all,
>>
>> I have a pretty huge Postgres DB, about 1,3 to 1,5 Terra. What do you guys
>> recommend on RAID Levels for this Database. Which does Postgres recommend,
>> and with which do Postgres run very good or in the best way?
>>
>
> We are running one ~2 TB database, mainly read-only stuff except for at
> batch import process every night. We are using RAID5 (RAID10 would require
> too many hard disk drives).
>
>
>> What Backup Strategy do you think would be the best. Dump the DB once a
>> week or work with the WAL`s? For your info, the data which is feeded to the
>> database is available and could be feeded again but it would maybe take a
>> couple of days. So what would be a solution to bring up the huge DB in about
>> one day after a crash. This would be the target.
>>
>
> I'd say that backup (using filesystem tools) the database once a week or
> fortnight and archive wals everyday. That's what we are doing and it's been
> working just fine.
>
> Regards
>
> Mikko
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: montaseri@gmail.com, mpartio@gmail.com, thomas.braeutigam@nexustelecom.com
Subject: Re: Recommended RAID for Postgres
In-Reply-To: <8078a1730807081112j6d49512kd1f738eb64ae20b0@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox