pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dan Harris <fbsd@drivefaster.net>
To: pgsql-admin@postgresql.org
Subject: Re: reindex in v8.2
Date: Tue, 19 Jun 2007 11:54:48 -0600
Message-ID: <46781868.5040108@drivefaster.net> (raw)
In-Reply-To: <004201c7b299$4ceb7bf0$b601a8c0@bwlaptop>
References: <004201c7b299$4ceb7bf0$b601a8c0@bwlaptop>

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.



view thread (3+ messages)

Message-ID: <46781868.5040108@drivefaster.net>
Permalink:  ../46781868.5040108@drivefaster.net/
Also on:    postgresql.org/message-id/46781868.5040108@drivefaster.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: fbsd@drivefaster.net
  Subject: Re: reindex in v8.2
  In-Reply-To: <46781868.5040108@drivefaster.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox