Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres for a "data warehouse", 5-10 TB - Mailing list pgsql-performance

From Igor Chudov
Subject Re: Postgres for a "data warehouse", 5-10 TB
Date
Msg-id CAMhtkAY2GvGiTz23V10Bev-ibrPWE7GowocT3KeWKm1EoED7WA@mail.gmail.com
Whole thread Raw
In response to Re: Postgres for a "data warehouse", 5-10 TB  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Postgres for a "data warehouse", 5-10 TB  (Andy Colson <andy@squeakycode.net>)
Re: Postgres for a "data warehouse", 5-10 TB  (Claudio Freire <klaussfreire@gmail.com>)
Re: Postgres for a "data warehouse", 5-10 TB  (Ogden <lists@darkstatic.com>)
List pgsql-performance
Tree view


On Sun, Sep 11, 2011 at 9:16 AM, Claudio Freire <klaussfreire@gmail.com> wrote:
On Sun, Sep 11, 2011 at 3:59 PM, Igor Chudov <ichudov@gmail.com> wrote:
> Well, right now, my server has twelve 7,200 RPM 2TB hard drives in a RAID-6
> configuration.
> They are managed by a 3WARE 9750 RAID CARD.
>
> I would say that I am not very concerned with linear relationship of read
> speed to disk speed. If that stuff is somewhat slow, it is OK with me.

With Raid 6 you'll have abysmal performance on write operations.
In data warehousing, there's lots of writes to temporary files, for
sorting and stuff like that.

You should either migrate to raid 10, or set up a separate array for
temporary files, perhaps raid 0.

Thanks. I will rebuild the RAID array early next week and I will see if I have a Raid 10 option with that card.

Quantitatively, what would you say is the write speed difference between RAID 10 and RAID 6?

pgsql-performance by date:

Previous
From: Andy Colson
Date:
Subject: Re: Postgres for a "data warehouse", 5-10 TB
Next
From: Andy Colson
Date:
Subject: Re: Postgres for a "data warehouse", 5-10 TB