]> git.ipfire.org Git - thirdparty/postgresql.git/commit
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)
commited9c9b033546129daf06d4aa013f5c0e22c5947d
tree17ecdb7c92b3a61a5d777b0f1121bb71c773d2e0
parent8d0155962e20c0981a4416b04857b7d997f116a5
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