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

Jeffrey Baker wrote:
> On Fri, Apr 18, 2008 at 10:32 AM, Jeffrey Baker <jwbaker@[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 Lin****angas
   EnterpriseDB   http://www.enterprisedb.com

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance