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.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
