From: Bill Willits <bwillits@cox.net>
To: pgsql-admin@postgresql.org
Subject: reindex in v8.2
Date: Tue, 19 Jun 2007 10:43:07 -0700
Message-ID: <004201c7b299$4ceb7bf0$b601a8c0@bwlaptop> (raw)
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
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: bwillits@cox.net
Subject: Re: reindex in v8.2
In-Reply-To: <004201c7b299$4ceb7bf0$b601a8c0@bwlaptop>
* 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