On Wed, Apr 6, 2022 at 7:49 AM Frédéric Yhuel <frederic.yh...@dalibo.com> wrote: > From the documentation > (https://www.postgresql.org/docs/current/sql-reindex.html#id-1.9.3.162.7), > it sounds like REINDEX won't block read queries that don't need the > index. But it seems like the planner wants to take an ACCESS SHARE lock > on every indexes, regardless of the query, and so REINDEX actually > blocks any queries but some prepared queries whose plan have been cached. > > I wonder if it is a bug, or if the documentation should be updated. What > do you think?
I've always thought that the docs for REINDEX, while technically accurate, are very misleading in practice. -- Peter Geoghegan
