Postgres Pro
Downloads
Home   >   mailing lists

Re: Allow sorts to use more available memory - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Allow sorts to use more available memory
Date
Msg-id CAOR=d=1WgWOPz+8t9FqqNbbabNKu6DOm-z0S1MJ0jGe+FsRGfw@mail.gmail.com
Whole thread Raw
In response to Allow sorts to use more available memory  (Robert Schnabel <schnabelr@missouri.edu>)
Responses Re: Allow sorts to use more available memory  (Robert Schnabel <schnabelr@missouri.edu>)
List pgsql-performance
Tree view 
On Mon, Sep 12, 2011 at 11:33 AM, Robert Schnabel
<schnabelr@missouri.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

pgsql-performance by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: Postgres for a "data warehouse", 5-10 TB
Next
From: Scott Marlowe
Date:
Subject: Re: Postgres for a "data warehouse", 5-10 TB