REINDEX and blocking SELECT queries
От | Satoshi Nagayasu |
---|---|
Тема | REINDEX and blocking SELECT queries |
Дата | |
Msg-id | CAA8sozcK9eOo0Cj0ufBpAYi=oL2cJ-T9T7JN-_CqpYSWZ0GDcg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: REINDEX and blocking SELECT queries
|
Список | pgsql-docs |
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 <snaga@uptime.jp>
В списке pgsql-docs по дате отправления: