Re: Marking indexes out of date (WAS: loading data, creating indexes, clustering, vacuum) feature request? - Mailing list pgsql-general

From Tom Lane
Subject Re: Marking indexes out of date (WAS: loading data, creating indexes, clustering, vacuum) feature request?
Date
Msg-id 25252.1165622394@sss.pgh.pa.us
Whole thread Raw
In response to Re: Marking indexes out of date (WAS: loading data, creating indexes, clustering, vacuum) feature request?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> One issue would be that even disabled indexes would need to be updated
> when there are new rows. If you don't update the index when it's
> disabled, then re-enabling will essentially need to rebuild the index.

I assume that's what he wants.  However, it's not immediately clear that
there's a sufficient use case for this to justify the extra apparatus
compared to just DROP INDEX (and recreate it later).

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Performance figures from DbMail list
Next
From: Luca Ferrari
Date:
Subject: help understanding analyze