Jeffrey Baker wrote:
> On Fri, Apr 18, 2008 at 10:32 AM, Jeffrey Baker <jwbaker@gmail.com> 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