Sam Mason <sam(at)samason(dot)me(dot)uk> writes:
> On Thu, Nov 13, 2008 at 02:59:34PM +0000, Grzegorz Jaaakiewicz wrote:
>> so how do I change it back to default (without knowing what the previous val
>> was). I suppose having it in a transaction won't do :P
> If by "default" you mean whatever was in the config file, you can do:
> set work_mem = default;
> A transaction followed by ROLLBACK appears to work as well.
Other alternatives worth reading about:
RESET work_mem
SET LOCAL work_mem
regards, tom lane