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 23:50:09
Message-ID: CAGTBQpbTWV20==C8YjWHdRcUUab2YpFqhnv5q7zP7=SMSsaBfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Sep 12, 2011 at 1:16 AM, Igor Chudov <ichudov(at)gmail(dot)com> wrote:
> I could, say, set work_mem to 30 GB? (64 bit linux)

I don't think you'd want that. Remember, work_mem is the amount of
memory *per sort*.
Queries can request several times that much memory, once per sort they
need to perform.

You can set it really high, but not 60% of your RAM - that wouldn't be wise.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alan Hodgson 2011-09-12 02:12:16 Re: RAID Controller (HP P400) beat by SW-RAID?
Previous Message Tomas Vondra 2011-09-11 23:17:56 Re: RAID Controller (HP P400) beat by SW-RAID?