On Mon, Sep 12, 2011 at 11:33 AM, Robert Schnabel <schnabelr@xxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance