Re: index question..

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: index question..
Date: 2002-11-13 11:08:53
Message-ID: 3DD2801D.22820.51D68FC@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 13 Nov 2002 at 5:56, Williams, Travis L, NPONS wrote:

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

AFAIU, indexes will keep themselves current but dropping and recreating them
wokrs like vacuum on indexes. IIRC vacuum does not recover deleted index space.

Correct me if I am wring..

Bye
Shridhar

--
Cold, adj.: When the politicians walk around with their hands in their own
pockets.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Areski 2002-11-13 11:22:49 Performance : Optimize query
Previous Message Shridhar Daithankar 2002-11-13 11:02:42 Re: Upgrade to dual processor machine?