Document concurrent indexes waiting on each other
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 30 Nov 2020 21:24:55 +0000 (18:24 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 30 Nov 2020 21:24:55 +0000 (18:24 -0300)
commit58ebe967f8a1e34a824d6a0a35728027272041c6
tree865410fc5aed0ebfeb0bfff190a1b57b833e4a0a
parent4823c4f6ac770ebd49b63b0ce64ecfe82987af57
Document concurrent indexes waiting on each other

Because regular CREATE INDEX commands are independent, and there's no
logical data dependency, it's not immediately obvious that transactions
held by concurrent index builds on one table will block the second phase
of concurrent index creation on an unrelated table, so document this
caveat.

Backpatch this all the way back.  In branch master, mention that only
some indexes are involved.

Author: James Coleman <jtc331@gmail.com>
Reviewed-by: David Johnston <david.g.johnston@gmail.com>
Discussion: https://postgr.es/m/CAAaqYe994=PUrn8CJZ4UEo_S-FfRr_3ogERyhtdgHAb2WG_Ufg@mail.gmail.com
doc/src/sgml/ref/create_index.sgml