Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iEkQE-0000kH-SL for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Sep 2019 01:24:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iEkQD-00019I-MD for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Sep 2019 01:24:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iEkQD-00018q-DL for pgsql-hackers@lists.postgresql.org; Mon, 30 Sep 2019 01:24:17 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iEkQA-0000WL-N3 for pgsql-hackers@postgresql.org; Mon, 30 Sep 2019 01:24:17 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 4E9CF4E0; Sun, 29 Sep 2019 21:24:12 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sun, 29 Sep 2019 21:24:12 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=getxR548Llh8lYC9vgudASSoKw+ 7vyHizaUhrk1MfpY=; b=enWavnQgkZXvD/9hJjYsU+9NhF+qTmjJ19E1a6+V3d6 fPG2YbmD8XuwPNoq+WmT25bMltgvHznCXBkFRc7Kcwh+cpf3irhoZnSXrf0uigIj 0KdR5UulEKF5lTImfqqG4vpzbh4JmqlWny7ykLE+Ot9ISxH9TydMgcfT8uldWpsc wN++qMzys6n2gocxFFGhZDq5F16SEWbtU6YLLvARdgcovimU6i5HwxVaeNAHCfhX Y05b5xFEE8uRGskjOtA8vwq4iUMtWYghnlLIQNjqVRwO1PL/McO0X+OIXfJ5UAvp uwpE3haPS5IFC8ClvvWHh6mmr/R/At16Nd+4hegKBQQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=getxR5 48Llh8lYC9vgudASSoKw+7vyHizaUhrk1MfpY=; b=RGIIkxY9heIQdD+anUEjbz NtAJ/fnYRjTj+ViKsz0nWm8vl0kn8mToXuPPjlvGA23vi6tcaOTVmKQGdFvBcTbU M9A229851OXWcQT6GER+dWVih55XHZejr+ZHeuB4peuW/TnKdVwqc3dIuceBHE19 xmBz3Cr6YMBOHJ4jRINuoIMJ6F3PrjtNahLyjRrzeUIgPFsr5zq7p5Gh6FOa9ZrS HoYSrp/ebeYYXE9F4pay0unD6P3wqIdQBZwiKcdiguCwwqz4YLpwUO7irZffQOcd Oy4ROBIfmlSAIbsLUC7UFCGs0N/LHpkl3WE3fY3MfVFGuhL0CvO/vYi7Ww1A8BHg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrgedugdeggecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdefhedmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfk phepudduuddruddtvddrudektddrudekheenucfrrghrrghmpehmrghilhhfrhhomhepmh hitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 0ACC08005B; Sun, 29 Sep 2019 21:24:08 -0400 (EDT) Date: Mon, 30 Sep 2019 10:24:06 +0900 From: Michael Paquier To: Alvaro Herrera Cc: Bruce Momjian , James Coleman , pgsql-hackers Subject: Re: [DOC] Document concurrent index builds waiting on each other Message-ID: <20190930012406.GC2888@paquier.xyz> References: <20190928161838.GD26853@momjian.us> <20190929012228.GA21412@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="EY/WZ/HvNxOox07X" Content-Disposition: inline In-Reply-To: <20190929012228.GA21412@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --EY/WZ/HvNxOox07X Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Sep 28, 2019 at 10:22:28PM -0300, Alvaro Herrera wrote: > I always thought that create index concurrently was prevented from > running concurrently in a table by the ShareUpdateExclusive lock that's > held during the operation. REINDEX CONCURRENTLY and CIC can deadlock while waiting for each other to finish after their validation phase, see: https://www.postgresql.org/message-id/20190507030756.GD1499@paquier.xyz https://www.postgresql.org/message-id/20190507032543.GH1499@paquier.xyz -- Michael --EY/WZ/HvNxOox07X Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl2RWTYACgkQnvQgOdby QH2tfxAAheSPDsCWZZ96F8eBcxxJuktzHnUPdd/SvabG7gun8CNLkP8krcfk5kMk lYCVL+5TCYXhI2A4hSUQNHvZRlSwHxrol7aKAHWywUH7ESNzN0uOcXm3+ub1wDyp HXAptEZ7EqirwQ9S8vPPgAxTOxLMMtobOowuietU25anassxlCrGZQPPvg/Z5JIO k8SC94dorOz8s5mG2t69yxdBBL/LHBSkQJuN51r/I4P+LUcOc90ba4uwkhT4OeGq flWwoWzljL9uueJLXIQpcxIRg8ackfwSPP1jAX3ZWZLWB8itXLiu5pCprs4iJ65g MgUvlS695N6WlTd/93q0R1buQrDvwjG+8PJkOdDt2ipUc/8Fi162XQKQDXmpw1c+ HYhXMi4F2XKnZKED+YHqFHVAMH9kwhO+iNpydpSgtrEQJtytauhxJp51l2f6fjtc sycVoALXZgTioW61yGKPp1R3TfcgS6+DPPnL1bdbdADXuGJnzic0hHRkCiDEK/uo myswwVw2chcUcpPxPose3Bu4A9hNyx0C/FguvWdpmes+n0Q9qT/swYmeFcn4BnEU 0c762OBPhYg3MEzrU2cAOiWVB+5pb0A9RxEWT6FMpZxFnghhKCO8+Y4Zck7f7NnT YKvR7GGGQWR/1aarS71pfN7EdMDAXuGwW3cSfffQhyXm1Kx4WYY= =3ahG -----END PGP SIGNATURE----- --EY/WZ/HvNxOox07X--