Re: Postgres for a "data warehouse", 5-10 TB

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Igor Chudov <ichudov(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres for a "data warehouse", 5-10 TB
Date: 2011-09-11 14:16:21
Message-ID: CAGTBQpYa+VUXtKZtUDLSosboSMgUEOCd_dkmCPA=4HkjHw2r2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, Sep 11, 2011 at 3:59 PM, Igor Chudov <ichudov(at)gmail(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andy Colson 2011-09-11 14:16:27 Re: Postgres for a "data warehouse", 5-10 TB
Previous Message Igor Chudov 2011-09-11 14:00:36 Re: Postgres for a "data warehouse", 5-10 TB