Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3FAD19FBE3C for ; Tue, 19 Jun 2007 14:55:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 29211-03 for ; Tue, 19 Jun 2007 14:55:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from crestone.coronasolutions.com (crestone.coronasolutions.com [66.45.104.24]) by postgresql.org (Postfix) with ESMTP id 20E449FBE7F for ; Tue, 19 Jun 2007 14:55:02 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by crestone.coronasolutions.com (Postfix) with ESMTP id B047E6447F5; Tue, 19 Jun 2007 11:54:59 -0600 (MDT) Received: from crestone.coronasolutions.com ([127.0.0.1]) by localhost (crestone.coronasolutions.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06216-06; Tue, 19 Jun 2007 11:54:50 -0600 (MDT) Received: from mac.local (c-76-25-77-161.hsd1.co.comcast.net [76.25.77.161]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by crestone.coronasolutions.com (Postfix) with ESMTP id B4420644809 for ; Tue, 19 Jun 2007 11:54:48 -0600 (MDT) Message-ID: <46781868.5040108@drivefaster.net> Date: Tue, 19 Jun 2007 11:54:48 -0600 From: Dan Harris User-Agent: Thunderbird 2.0.0.4 (Macintosh/20070604) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: reindex in v8.2 References: <004201c7b299$4ceb7bf0$b601a8c0@bwlaptop> In-Reply-To: <004201c7b299$4ceb7bf0$b601a8c0@bwlaptop> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at coronasolutions.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/187 X-Sequence-Number: 25855 Bill Willits wrote: > Hello: > > We are in the process of upgrading posgres from v7.3.9 to v8.2.4 In our > current environment (v7.3), we run a reindex operation on all tables to > recover space and improve performance (we have several tables with high > insert/update load - no deletes). Is it likely that the reindex will > still be beneficial after the upgrade? Or has the pg code changed such > that this operation is obsolete? > > Thanks in advance. > Bill Willits When you reload your dump file into 8.2, the indexes should be created fresh and AFAIK, a reindex at that point would not gain anything for you.