pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruno Wolff III <bruno@wolff.to>
To: Bill Chandler <billybobc1210@yahoo.com>
Cc: pgsql-perform <pgsql-performance@postgresql.org>
Subject: Re: Question on REINDEX
Date: Mon, 18 Apr 2005 14:53:58 -0500
Message-ID: <20050418195358.GA4961@wolff.to> (raw)
In-Reply-To: <20050418192142.84419.qmail@web51405.mail.yahoo.com>
References: <20050418192142.84419.qmail@web51405.mail.yahoo.com>

On Mon, Apr 18, 2005 at 12:21:42 -0700,
  Bill Chandler <billybobc1210@yahoo.com> wrote:
> 
> Running PostgreSQL 7.4.2 on Solaris.
> 
> 1) When is it necessary to run REINDEX or drop/create
> an index?  All I could really find in the docs is:
> 
> "In some situations it is worthwhile to rebuild
> indexes periodically with the REINDEX command. (There
> is also contrib/reindexdb which can reindex an entire
> database.) However, PostgreSQL 7.4 has substantially
> reduced the need for this activity compared to earlier
> releases."

In pathologic cases it is possible to have a lot of empty space on a lot
of your index pages. Reindexing would change that to a smaller number.
In earlier versions, I think it was possible to have completely empty
pages and this happened for patterns of use (new values monotonically
increasing, oldest values deleted first) that were actually seen in
practice.



view thread (12+ messages)  latest in thread

Message-ID: <20050418195358.GA4961@wolff.to>
Permalink:  ../20050418195358.GA4961@wolff.to/
Also on:    postgresql.org/message-id/20050418195358.GA4961@wolff.to

 · 

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-performance@postgresql.org
  Cc: bruno@wolff.to, billybobc1210@yahoo.com
  Subject: Re: Question on REINDEX
  In-Reply-To: <20050418195358.GA4961@wolff.to>

* 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