On Fri, Nov 25, 2016 at 11:14 AM, Sameer Kumar <sameer.ku...@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 are trying 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
