| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Bill Willits <bwillits(at)cox(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: reindex in v8.2 |
| Date: | 2007-06-19 17:52:50 |
| Message-ID: | 20070619175250.GB21268@alvh.no-ip.org |
| 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?
The index code was improved in 7.4, but some reindexing is still needed
in (rarer) corner cases. Try getting rid of the reindex and track your
indexes sizes for a while. If you don't notice a problem you can forget
it entirely. Most people gets away without it.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Harris | 2007-06-19 17:54:48 | Re: reindex in v8.2 |
| Previous Message | Bill Willits | 2007-06-19 17:43:07 | reindex in v8.2 |