Re: index question..

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Williams, Travis L, NPONS" <tlw(at)att(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: index question..
Date: 2002-11-13 17:21:41
Message-ID: Pine.LNX.4.33.0211131020530.31179-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2002-11-13 17:21:50 Re: Upgrade to dual processor machine?
Previous Message scott.marlowe 2002-11-13 17:20:45 Re: index question..