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