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

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@gregsmith.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