projects / users / gsingh / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: cd959b1) | patch
doc: Clarify behavior of query planner locking with REINDEX
authorMichael Paquier <michael@paquier.xyz>
Mon, 11 Apr 2022 00:49:13 +0000 (09:49 +0900)
committerMichael Paquier <michael@paquier.xyz>
Mon, 11 Apr 2022 00:49:13 +0000 (09:49 +0900)
commit8ac700acffc7b17d88414be47b8dff44fb1ea681
tree1a3d8ac5a775424f79c7bd028bd06c97edb46df6tree
parentcd959b1b0662c9d57540b31961680c38037ffcd6commit | diff
doc: Clarify behavior of query planner locking with REINDEX

The documentation of REINDEX has never mentioned that the query planner
may take an ACCESS SHARE lock on the indexes depending on the query
used.  This adds also a note about prepared queries not impacted when
they do not use the index(es) rebuilt.

Author: Frédéric Yhuel
Reviewed-by: Guillaume Lelarge, Justin Pryzby
Discussion: https://postgr.es/m/65d08718-6f11-978a-4b5a-72b807d4c663@dalibo.com
doc/src/sgml/ref/reindex.sgml diff | blob | blame | history
Postgres clone for personal branches