Document concurrent indexes waiting on each other

Alvaro Herrera <alvherre@alvh.no-ip.org>

Commit: b2603f16ad7531a5e09b1f38a0b4382a946a139f
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2020-11-30T21:24:55Z
Releases: 12.6
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

Files

PathChange+/−
doc/src/sgml/ref/create_index.sgml modified +2 −1

Documentation touched

Discussion