[Pkg-postgresql-public] GiST rebuild

[Markus Wanner]

Hi,

Gerfried Fuchs wrote:
>  What times are we talking here? Times like the locales regeneration on
> each update, longer, shorter? Is that a one-time thing or one that would
> be needed with every future update, too?

Depends entirely on the amount and size of GiST indices and the
complexity of the function to recalculate Datums to be indexed.

>  Really depends on the impact of not doing so and the time it takes. If
> the impact of not doing so is pretty low, if the time it takes can be
> quite long, I definitely would vote for not doing it. If on the other
> hand those databases would stop working and it doesn't take any time at
> all, I rather would push it, too.

AFAIU the worst that can happen is that the database system doesn't find
tuples it *should* find with the GiST index.

Regards

Markus Wanner