Re: sort_mem param of postgresql.conf - Mailing list pgsql-general

From Tom Lane
Subject Re: sort_mem param of postgresql.conf
Date
Msg-id 20913.1226605355@sss.pgh.pa.us
Whole thread Raw
In response to Re: sort_mem param of postgresql.conf  (Sam Mason <sam@samason.me.uk>)
Responses Re: sort_mem param of postgresql.conf
List pgsql-general
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

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: Upgrading side by side in Gentoo
Next
From: "David Wilson"
Date:
Subject: Re: Table bloat in 8.3