pgsql: Document concurrent indexes waiting on each other

2020-11-30 Thread Alvaro Herrera
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 a

pgsql: Document concurrent indexes waiting on each other

2020-11-30 Thread Alvaro Herrera
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 a

pgsql: Document concurrent indexes waiting on each other

2020-11-30 Thread Alvaro Herrera
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 a

pgsql: Document concurrent indexes waiting on each other

2020-11-30 Thread Alvaro Herrera
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 a

pgsql: Document concurrent indexes waiting on each other

2020-11-30 Thread Alvaro Herrera
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 a

pgsql: Document concurrent indexes waiting on each other

2020-11-30 Thread Alvaro Herrera
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 a

pgsql: Document concurrent indexes waiting on each other

2020-11-30 Thread Alvaro Herrera
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 a