Re: max_fsm_relations

In response to "Gauthier, Dave" <dave.gauthier@intel.com>:

> Ya, most of it's system stuff.  OK, I see where the 1000 comes from.  I bumped it up to 1200 in postgresql.conf.  Is
therea way I can spin that in without rebooting the DB (and kicking my user off)? 

No.  Unless something has changed that I'm not aware of, you have to do
a restart for PG to change that value, as it allocates the memory on
startup.

Unless you're expecting a considerable amount of table bloat in the
near future, you can just reset the value, then schedule the server
to restart during your next off-peak time.  The server's not going to
meltdown immediately (unless you've got a _TON_ of update activity)

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/