Re: reindex in v8.2

[Dan Harris <fbsd@xxxxxxxxxxxxxxx>]

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.