Sam Mason <[EMAIL PROTECTED]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
