From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Jeffrey Baker <jwbaker@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: 3-days-long vacuum of 20GB table
Date: Sat, 19 Apr 2008 08:57:11 +0300
Message-ID: <480989B7.3050806@enterprisedb.com> (raw)
In-Reply-To: <fd145f7d0804181034j50ffb420s4b4144636d886087@mail.gmail.com>
References: <fd145f7d0804180935w7d0052degf79a9660b043c084@mail.gmail.com>
<3630.1208538238@sss.pgh.pa.us>
<fd145f7d0804181032w5dd56caj608866297120984a@mail.gmail.com>
<fd145f7d0804181034j50ffb420s4b4144636d886087@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: heikki@enterprisedb.com, jwbaker@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: 3-days-long vacuum of 20GB table
In-Reply-To: <480989B7.3050806@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox