| 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: | Whole Thread | Raw Message | 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.
| 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 |