Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D94A6B5DBF4 for ; Sat, 9 Jul 2011 09:15:27 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 68299-05 for ; Sat, 9 Jul 2011 12:15:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from www.postnewspapers.com.au (www.postnewspapers.com.au [173.230.139.50]) by mail.postgresql.org (Postfix) with ESMTP id 96FF0B5DBC4 for ; Sat, 9 Jul 2011 09:15:21 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by www.postnewspapers.com.au (Postfix) with ESMTP id 5997714A2; Sat, 9 Jul 2011 08:15:21 -0400 (EDT) X-Virus-Scanned: amavisd-new at postnewspapers.com.au.com Received: from www.postnewspapers.com.au ([127.0.0.1]) by localhost (www.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id pNyIgKploQwp; Sat, 9 Jul 2011 08:15:20 -0400 (EDT) Received: from mail.postnewspapers.com.au (ppp171-128.static.internode.on.net [150.101.171.128]) by www.postnewspapers.com.au (Postfix) with ESMTP id 69E9B14A1; Sat, 9 Jul 2011 08:15:20 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id 0757CAF5BF; Sat, 9 Jul 2011 20:15:19 +0800 (WST) X-Amavis-Modified: Mail body modified (using disclaimer) - mail.postnewspapers.com.au X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (mail.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id wUETDu4lf+uF; Sat, 9 Jul 2011 20:15:14 +0800 (WST) Received: from [10.1.1.7] (124-169-57-156.dyn.iinet.net.au [124.169.57.156]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id 1CEEDAF5BE; Sat, 9 Jul 2011 20:15:14 +0800 (WST) Message-ID: <4E18464F.1040209@postnewspapers.com.au> Date: Sat, 09 Jul 2011 20:15:11 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20110624 Thunderbird/5.0 MIME-Version: 1.0 To: Gael Le Mignot CC: Guillaume Lelarge , pgsql-performance@postgresql.org Subject: Re: Memory usage of auto-vacuum References: <1310200383.2101.8.camel@laptop> 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-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201107/62 X-Sequence-Number: 44274 On 9/07/2011 4:43 PM, Gael Le Mignot wrote: > maintenance_work_mem is at 16Mb, shared_buffers at 24Mb. Woah, what? And you're hitting a gigabyte for autovacuum? Yikes. That just doesn't sound right. Are you using any contrib modules? If so, which ones? Are you able to post your DDL? How big is the database? (Not that it should matter). -- Craig Ringer POST Newspapers 276 Onslow Rd, Shenton Park Ph: 08 9381 3088 Fax: 08 9388 2258 ABN: 50 008 917 717 http://www.postnewspapers.com.au/