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)
commit968a537b432eb19001ad5788023aabe0a009aa16
tree34e5db5c35cecd4b93f38eee91994b1e4a71cc6a
parent8c5da2d512e3e00c55f3f8fb7af12dfabc5b9284
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: http://postgr.es/m/CAAaqYe994=PUrn8CJZ4UEo_S-FfRr_3ogERyhtdgHAb2WG_Ufg@mail.gmail.com
doc/src/sgml/ref/create_index.sgml