On Thu, Nov 13, 2008 at 02:59:34PM +0000, Grzegorz Jaaakiewicz wrote:
> On Wed, Nov 12, 2008 at 11:08 PM, Greg Smith <gsmith(at)gregsmith(dot)com> 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