Re: index question..

I thought reindexing was only to be used on corrupt tables.. will
vacumming fix the problem?

Travis

-----Original Message-----
From: scott.marlowe [mailto:scott.marlowe@ihs.com]
Sent: Wednesday, November 13, 2002 11:22 AM
To: Williams, Travis L, NPONS
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] index question..


On Wed, 13 Nov 2002, Williams, Travis L, NPONS wrote:

> Do indexs need to be dropped/recreated or reindex'd or something to
keep them current?

Indexes are updated on the fly.  But sometimes they lose track of
deleted
index entries and to regain space and improve performance, reindexing
may
be necessary for certain circumstances.