On Wednesday, 16 April 2014 10:05 PM, Nick Eubank <nickeubank@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