Re: index question.. - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: index question..
Date
Msg-id 3DD2801D.22820.51D68FC@localhost
Whole thread Raw
In response to index question..  ("Williams, Travis L, NPONS" <tlw@att.com>)
Responses Re: index question..  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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.


pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Upgrade to dual processor machine?
Next
From: "Areski"
Date:
Subject: Performance : Optimize query