Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 21C951337BBA for ; Fri, 1 Apr 2011 00:42:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 06209-01 for ; Fri, 1 Apr 2011 03:41:49 +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 EEC841337B82 for ; Fri, 1 Apr 2011 00:41:48 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by www.postnewspapers.com.au (Postfix) with ESMTP id B5FDAEB; Thu, 31 Mar 2011 23:41:48 -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 FIeUIo0xqv5B; Thu, 31 Mar 2011 23:41:48 -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 DFCDB2D; Thu, 31 Mar 2011 23:41:47 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id E1D4DAE3C8; Fri, 1 Apr 2011 11:41:46 +0800 (WST) 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 y1MtnBruHYKz; Fri, 1 Apr 2011 11:41:41 +0800 (WST) Received: from [10.1.1.3] (58-7-255-44.dyn.iinet.net.au [58.7.255.44]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id 6B6996002; Fri, 1 Apr 2011 11:41:41 +0800 (WST) Message-ID: <4D95496E.1050407@postnewspapers.com.au> Date: Fri, 01 Apr 2011 11:41:34 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9 MIME-Version: 1.0 To: Chris CC: pgsql-performance@postgresql.org Subject: Re: good old VACUUM FULL References: <4D89760A.3040109@gmail.com> In-Reply-To: <4D89760A.3040109@gmail.com> 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: 201104/1 X-Sequence-Number: 43063 On 23/03/2011 12:24 PM, Chris wrote: > You'll need to reindex that table now - vacuum full can bloat your > indexes which will affect your other queries. It doesn't seem to matter much for a one-off. Index bloat problems have mainly been encountered where people are running VACUUM FULL as part of routine maintenance - for example, from a nightly cron job. -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/