On Wednesday, 16 April 2014 10:05 PM, Nick Eubank <nickeub...@gmail.com> wrote:
>Amul: thanks for the followup! Unfortunately, setting locally faces the same >limitation >as setting things in the config file -- >I get an "ERROR: 3072000 is outside the valid range for parameter "work_mem" >(64 .. 2097151) >SQL state: 22023" problem if I set above ~1.9gb. :( yes, you can set work_mem upto 2047MB. Regards, Amul Sul -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
