Re: max_fsm_relations

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@gregsmith.com http://www.gregsmith.com Baltimore, MD