Re: reindex in v8.2

From: Dan Harris <fbsd(at)drivefaster(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: reindex in v8.2
Date: 2007-06-19 17:54:48
Message-ID: 46781868.5040108@drivefaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2007-06-19 18:55:30 Re: archive_command does not execute
Previous Message Alvaro Herrera 2007-06-19 17:52:50 Re: reindex in v8.2