Jeffrey Baker wrote:
On Fri, Apr 18, 2008 at 10:32 AM, Jeffrey Baker <[EMAIL PROTECTED]> wrote:
# show maintenance_work_mem ;
maintenance_work_mem
----------------------
16384
That appears to be the default. I will try increasing this. Can I
increase it globally from a single backend, so that all other backends
pick up the change, or do I have to restart the instance?
You can change it in the config file, and send postmaster the HUP
signal, which tells all backends to reload the file. "killall -HUP
postmaster" or similar.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance