On Thu, Nov 13, 2008 at 02:59:34PM +0000, Grzegorz Jaaakiewicz wrote: > On Wed, Nov 12, 2008 at 11:08 PM, Greg Smith <[EMAIL PROTECTED]> wrote: > > Generally, if it's only a report or two that > > need a lot more working memory for sorts, you can do this at the beginning > > of them instead: > > > > set work_mem='512MB'; > > 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. Sam -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
