pgsql: Document concurrent indexes waiting on each other

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Document concurrent indexes waiting on each other
Date: 2020-11-30 21:26:16
Message-ID: E1kjqga-0005FM-Lg@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(at)gmail(dot)com>
Reviewed-by: David Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAAaqYe994=PUrn8CJZ4UEo_S-FfRr_3ogERyhtdgHAb2WG_Ufg@mail.gmail.com

Branch
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b3d33bf598dd64c95f48111081b6672ec0dc380e

Modified Files
--------------
doc/src/sgml/ref/create_index.sgml | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2020-11-30 21:33:54 pgsql: Fix missing outfuncs.c support for IncrementalSortPath.
Previous Message Tom Lane 2020-11-30 20:24:32 pgsql: Remove configure-time probe for DocBook DTD.