Re: Permanent settings

Dawid Kuroczko escribió:

> 1) changes that cannot be done to live server:
> 
> SET PERMANENT shared_buffers = '1GB';
> 
> Now, this is a setting that cannot be changed "live", but it should be
> changeable.  And we need a command to query what's permanent
> and what's current.

IMO restart-only settings should not be changeable via the new SQL
command.  It's just too messy to deal with that.

Also, this SQL command should reject being used in a transaction block
(BEGIN/COMMIT), because rolling it back seems fragile.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support