Re: max_fsm_relations

[Bill Moran <wmoran(at)potentialtech(dot)com>]

In response to "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)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 there a 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/