]> 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)
commitd3bd36a63d6995da2a25719372baca0275c86374
treeaa67e83ef64aebba7a0fba44fecb51dccd5525b5
parent785f4462daaf6897ab3ac56b3170c2f988d0e93f
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