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