Re: sort_mem param of postgresql.conf

Sam Mason <sam@samason.me.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