Re: Allow sorts to use more available memory

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Robert Schnabel <schnabelr(at)missouri(dot)edu>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Allow sorts to use more available memory
Date: 2011-09-12 20:58:51
Message-ID: CAOR=d=1WgWOPz+8t9FqqNbbabNKu6DOm-z0S1MJ0jGe+FsRGfw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Sep 12, 2011 at 11:33 AM, Robert Schnabel
<schnabelr(at)missouri(dot)edu> wrote:
> The recent "data warehouse" thread made me think about how I use work_mem
> for some of my big queries.  So I tried SET work_mem = '4GB' for a session
> and got
>
> ERROR: 4194304 is outside the valid range for parameter "work_mem" (64 ..
> 2097151)

Ubuntu 10.10, pgsql 8.4.8:

smarlowe=# set work_mem='1000GB';
SET

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2011-09-12 21:00:29 Re: Postgres for a "data warehouse", 5-10 TB
Previous Message Shaun Thomas 2011-09-12 20:55:43 Re: Postgres for a "data warehouse", 5-10 TB