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

reindex in v8.2

From: "Bill Willits" <bwillits(at)cox(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: reindex in v8.2
Date: 2007-06-19 17:43:07
Message-ID: 004201c7b299$4ceb7bf0$b601a8c0@bwlaptop (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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


pgsql-admin by date

Next:From: Alvaro HerreraDate: 2007-06-19 17:52:50
Subject: Re: reindex in v8.2
Previous:From: Kevin GrittnerDate: 2007-06-19 17:27:32
Subject: Re: archive_command does not execute

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