Re: 3-days-long vacuum of 20GB table

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