Skip site navigation (1) Skip section navigation (2)

Re: reindex in v8.2

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 (view raw or flat)
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.

In response to

pgsql-admin by date

Next:From: Dan HarrisDate: 2007-06-19 17:54:48
Subject: Re: reindex in v8.2
Previous:From: Bill WillitsDate: 2007-06-19 17:43:07
Subject: reindex in v8.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group