Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id D4F102E0062 for ; Sat, 19 Apr 2008 02:57:22 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 23298-09 for ; Sat, 19 Apr 2008 02:57:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.152]) by developer.postgresql.org (Postfix) with ESMTP id 17FC92E003D for ; Sat, 19 Apr 2008 02:57:18 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 22so755587fge.23 for ; Fri, 18 Apr 2008 22:57:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:organization:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; bh=2dAbrMtdwToX+9IKk5XFvMXkU6kX7vMifMC7B1pM4iE=; b=pcw9F1CKMAsn+brtsxWUckMfFh7NoeQJT7Z5Qkx8sxWscgJws2TxWnFJiLpkbv2hmbXosVceWJi7FvILMgnyGDyACIve9roob/TdB/UhCafl8RqyL1+FSLtMJVdmfLERIEAGrc4Mv7Inhy487ZPOxH5FkQPfv9RhOv6xjxWuAoE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:organization:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=n9zbPb6uw8XnROkzp17iCNzIEZJIv8hMKelJJSchBxkDOmkCd4JAMlX/J2RxpRbyLUqUpCi1cY6pKVHDt6bGKYxeeaS76AscxIVG/MaKasSaH3BcaO0jt8wLdpnBmB1e0SNBK9BTpCFpLBGLCZ7XB5JWnpnzQGOeZQ1W4HGPgCI= Received: by 10.82.186.19 with SMTP id j19mr6140498buf.2.1208584637562; Fri, 18 Apr 2008 22:57:17 -0700 (PDT) Received: from ?192.168.0.199? ( [80.222.108.74]) by mx.google.com with ESMTPS id 6sm7866582nfv.5.2008.04.18.22.57.12 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 18 Apr 2008 22:57:15 -0700 (PDT) Message-ID: <480989B7.3050806@enterprisedb.com> Date: Sat, 19 Apr 2008 08:57:11 +0300 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.9 (X11/20080110) MIME-Version: 1.0 To: Jeffrey Baker CC: Tom Lane , pgsql-performance@postgresql.org Subject: Re: 3-days-long vacuum of 20GB table References: <3630.1208538238@sss.pgh.pa.us> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/283 X-Sequence-Number: 29776 Jeffrey Baker wrote: > On Fri, Apr 18, 2008 at 10:32 AM, Jeffrey Baker 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