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