On Fri, Nov 25, 2016 at 11:14 AM, Sameer Kumar <sameer.kumar@ashnik.com> wrote:
> Does this mean that you reindex quite often based on a schedule. Personally I don't prefer that. To me it is like you
aretrying to fix something that is not broken.
>
> Ideally reindex only what needs to be reindexed. I would not want to reindex a table in OLTP env.
Like VACUUM FULL, don't forget that REINDEX needs an exclusive lock
when working. As that's very intrusive, usually you take measures on
your database to be sure that you *never* require it, particularly if
this is a production instance.
--
Michael