Hi all, According to the manual, running REINDEX does not take any locks on the parent table which block read operations.
> REINDEX locks out writes but not reads of the index's parent table. REINDEX https://www.postgresql.org/docs/9.5/static/sql-reindex.html However, I heard some complains from a few people that this explanation would lead some misunderstanding that REINDEX would not block SELECT queries on the table. Actually, REINDEX blocks SELECT queries, maybe in the planning phase. This explanation is very critical for many people because they are planning to run REINDEX online with believing in the explanation. So, I think we should improve this explanation precisely not to lead such misunderstanding. What do you think? Any comments? Regards, -- Satoshi Nagayasu <sn...@uptime.jp> -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
