Re: Permanent settings

On Wed, Feb 20, 2008 at 7:34 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Josh Berkus <josh@agliodbs.com> writes:
>
> > 2) allow *commenting* of pg_settings / SET PERMANENT.  Thus:
>
>  > SET PERMANENT work_mem = '12mb' COMMENT '16mb too high; OOM';
>
>  Ugh :-(
>
>  I think that putting this into SET is a pretty bad idea in any case.
>  SET is, and always has been, a session-local operation.  Providing a
>  secondary option that transforms it into something completely different

I think that's valid argument.

We already have ALTER USER foo SET bar = baz, so why not something like:

ALTER CLUSTER SET shared_buffers TO '2GB';

...perhaps with some other word than CLUSTER?

Regards,  Dawid