Sam Mason <sam@xxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
