In response to "Gauthier, Dave" <dave.gauth...@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 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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
