Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfaOf-0003Bz-1N for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Nov 2020 03:14:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kfaOc-0006T1-Ue for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Nov 2020 03:14:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfaOb-0006Su-LH for pgsql-hackers@lists.postgresql.org; Thu, 19 Nov 2020 03:14:06 +0000 Received: from [64.147.123.24] (helo=wout1-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfaOY-0007gh-UD for pgsql-hackers@lists.postgresql.org; Thu, 19 Nov 2020 03:14:04 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 34247BDC; Wed, 18 Nov 2020 22:13:51 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 18 Nov 2020 22:13:51 -0500 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=fm3; bh=m7UJXJJr+38lhlB/dbf/a3OcNGH 8BIk4ZJNo+631Img=; b=dkjVhqwjTJtzfQfx7w3FKw1XgqQvl+CWauFKcSWj0r7 K6rqoyS3hzAGlwo0hL7hwADyp6JW1XFhN+oOXhdVHcfRqJh/ouwFYFRY3wkja3dr oVhBPeQ4TiDj4Oyjf9W4dRHejhyy+c8gmbcITNJPAWM5hbq/VC+OIcTkRLpmgMwQ gwThcmzYqxX1LAie8k/zigO0dbovlFqlntPpn0Y3R3wvHaMCdD0WdXAI48c+5Kao TZwG232TgAJOI2W0kFigKCaydGknoQFld4N14gsZmmc0vQk4ZocLG29AHQiku9aD mKUys3HyxmhdMB4A8K/8SxbNtGiqqkbMmj7G0a/OHQQ== 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=fm1; bh=m7UJXJ Jr+38lhlB/dbf/a3OcNGH8BIk4ZJNo+631Img=; b=jK8SXof0oFuGY4eLKHYygr pQlkmcl4en7Rj57fbqPtsjBp1DGj+7lAX6HeP5CWzaLbbrVb9d1vBeLsdzdZgyfD bZERlBfOJuzBfAIgZid2N+l7ufmNRY0v7e3uLQAJYv86cYpa+HEj+cjB/pO8Co5V 031dXyjOt2+B4iY7T5tL1evRQ7p38rYp7n2b+mgekE5LYgAEttR+sGsvG8vPjkIv 4Y6Q1S8gtxNUQQY/EyTGCrmXOA8nphG7lA3Dq7URrcVRLf5+2VEZllg7hlfLTyR7 IzMjWPvRIZnVlLDxnRSqltJSstWXoufuPQjBTAR7nLuUzJlxn6wrqEX5+qekqNJg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrudefiedgheehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucfkphepudduuddruddtvddrudektd drudekheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii 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 5742B3064AAA; Wed, 18 Nov 2020 22:13:48 -0500 (EST) Date: Thu, 19 Nov 2020 12:13:44 +0900 From: Michael Paquier To: Andres Freund Cc: Alvaro Herrera , Tom Lane , Dmitry Dolgov <9erthalion6@gmail.com>, James Coleman , Pg Hackers Subject: Re: "as quickly as possible" (was: remove spurious CREATE INDEX CONCURRENTLY wait) Message-ID: <20201119031344.GD26172@paquier.xyz> References: <20201118190928.vnztes7c2sldu43a@alap3.anarazel.de> <20201118214127.GA3179@alvherre.pgsql> <20201118224840.g72ptl7tbkdcvyau@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="veXX9dWIonWZEC6h" Content-Disposition: inline In-Reply-To: <20201118224840.g72ptl7tbkdcvyau@alap3.anarazel.de> X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.147.123.24 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --veXX9dWIonWZEC6h Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Nov 18, 2020 at 02:48:40PM -0800, Andres Freund wrote: > On 2020-11-18 18:41:27 -0300, Alvaro Herrera wrote: >> We could make this more concurrent by copying lock->tag to a local >> variable, releasing the lock, then doing all the string formatting and >> printing. See attached quickly.patch. >=20 > Sounds like a plan. +1. >> Now, when this code was written (d7318d43d, 2012), this was a LOG >> message; it was demoted to DEBUG1 later (d8f15c95bec, 2015). I think it >> would be fair to ... remove the message? Or go back to Simon's original >> formulation from commit acac68b2bca, which had this message as DEBUG2 >> without any string formatting. >=20 > I don't really have an opinion on this. That still looks useful for debugging, so DEBUG1 sounds fine to me. -- Michael --veXX9dWIonWZEC6h Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl+14ugACgkQnvQgOdby QH0VIw//ZWO3DdqOWJTNWxY7s8QiJrgb6GEz7hC9pVwGXozGvRbYjtTmvyAmslrR F18yPzDHGQ6Dx+KEw0Rvb2ldrm6wDM9W0IGZW6DtXNFKS3tzJkZsmqqgS+D6ogTk iShP1ibqOJkqfAe6oWO88XYDtF42Cztvbxn+LTHTmfln/F6rAsD6Kri8mn7DsgZC SVxq9eqAftG+COreDC1w05E3zXQHnPvh6X3zpt5wAFGeEv5IcywKNDR/bLfksddz 9Ln2LlbyrEFbo5Q0Zc4C1BZd7Mc0OLSyxDwnbfuEgEemEmGvTams1Bs6rDu9wCwd UUhJggG9PnfJFJVtFSZ1dKSoBSKlTuiHGENbFkXdhnnKwvOvAMATyXtlsfQqwm8O FgrRkMniJoAhCMeKoeyZsl2ebD+G0VhNnBRpVt78CnhIHA7U837h3j5udlJoQ0Jw LZ2DppI/+dxh9qmoLDga8gv+iySfq/2MqDY0FbDNZDbrRDNWLU5U7Nrtfncr/bBB be32VtfIEz1J3Q0kp2wML7L8gHINHD6SGmILUfJxSvcgCWhcR0pGBmi2md/nyqvY RPr9tW6M8Tr/fAVdC9x1K2KnYb3YVPAxZuRtUWV8KaVHoMk01C25sKBNGy5nzUxv 60ZKhwy/TiniA2X3ctVMvz+aLPMwSIESV3eUtEtuRab2exRsyy8= =hXmN -----END PGP SIGNATURE----- --veXX9dWIonWZEC6h--