Re: max_fsm_relations

[Greg Smith <gsmith(at)gregsmith(dot)com>]

On Fri, 27 Feb 2009, Gauthier, Dave wrote:

> Is there a way I can spin that in without rebooting the DB (and kicking 
> my user off)?

Nope:

# select name,context from pg_settings where name='max_fsm_pages';
     name      |  context
---------------+------------
 max_fsm_pages | postmaster

That's the definitive way to answer questions like this.  See "When they 
take effect" at 
http://www.postgresqldocs.org/wiki/Tuning_Your_PostgreSQL_Server for a 
quick description of what the context stuff means.  "postmaster" means you 
need to restart the server, in this case (like many of the other 
parameters in that class) because the parameter changes a shared memory 
allocation, which is only done at startup.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD