On Wednesday, 16 April 2014 10:05 PM, Nick Eubank <nickeubank@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
