Re: index question..

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(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 15:13:03
Message-ID: 20021113070931.R79695-100000@megazone23.bigpanda.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?

They'll stay current, but you may find that the vacuum
doesn't reclaim all of the empty space in the index in
which case you may want to reindex for space and performance
reasons.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-11-13 15:15:51 Re: error: lost syncronization with server
Previous Message Tom Lane 2002-11-13 14:58:22 Re: Comparing strings with non-ASCII characters