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 1jeXay-0000Pr-0T for pgsql-bugs@arkaria.postgresql.org; Fri, 29 May 2020 05:30:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jeXaw-0007sr-Pp for pgsql-bugs@arkaria.postgresql.org; Fri, 29 May 2020 05:30:14 +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 1jeXau-0007sk-Uk for pgsql-bugs@lists.postgresql.org; Fri, 29 May 2020 05:30:14 +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 1jeXan-0004rT-Um for pgsql-bugs@lists.postgresql.org; Fri, 29 May 2020 05:30:11 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id E563C8E5; Fri, 29 May 2020 01:29:53 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Fri, 29 May 2020 01:29:54 -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=fm1; bh=HKGC8EjQo3xosb+SZyBgq0EaDkx FlF+78NkM7NOILAc=; b=SHNGMM7hwFOGBsbLqmIY2gY9DQS39qk2Q5emDFQJD8i X66EeLExinNeLiKiTWszmba+nGyES3HIGkGF7y0HhOV0oP3o4kj4wgT//OQ2WPfG gJmbHVlLJ+fMjYLl7SydGP9Qn3j2FL7l4yPnjsR97vH1o/g60UMDFAU/N6B6wYsR BEiskevlfCo7wGTuUWBck4DxjRXcsMnGL92T5GWgiboazIaQHl9JH06SpR2Ty4zz HqKkM2fS3+nvh5eeK+v5ZC71Ku/F8wDbXwfR1o0Mw58ds8YC9y/8taa2umuEdyjf 06h2wly7moVWfrW6M2yJRRs6PTApj6KLWWEeikraVLQ== 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=fm2; bh=HKGC8E jQo3xosb+SZyBgq0EaDkxFlF+78NkM7NOILAc=; b=PCDdUIZgFGYT+m/F6VyPbj MyAkclifAL3YYZpIDAQOA4KGtnvjNeNjGksA0PjTG5852+4UjF/GZbrMcd3u88rY 6fMT3t3ZzN6YjWrp1ypSL4Iq9HPXoYVTwOImMzNPc30JH08aoZhX3Dhs9A06tPKt vn4xq044ymwsy7oORffBI9IVdyW0hN3GEdnlZ2hu+QmdLpO4ch/i+RqxFXyjIM3j 4piB9oQwpXw1pT0QhBkSH9dMzpd5yqtVvKHXYObpUC7tSDdJLEWDh5WyD//ywNLP WCKJ1rSAu313ehPYqiPIGuWpyBH6fcPAMNrufjSBG0vINaqgsJpbueOW+GGyGKWg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedruddvjedgleduucetufdoteggodetrfdotf 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 DDCCA328005D; Fri, 29 May 2020 01:29:51 -0400 (EDT) Date: Fri, 29 May 2020 14:29:39 +0900 From: Michael Paquier To: Tom Lane Cc: Andrey Klychkov , Peter Eisentraut , pgsql-bugs@lists.postgresql.org Subject: Re: Re[2]: Message-ID: <20200529052939.GD44192@paquier.xyz> References: <1590486572.205117372@f500.i.mail.ru> <1590501239.839686286@f437.i.mail.ru> <17907.1590504619@sss.pgh.pa.us> <20200527074736.GG103662@paquier.xyz> <5816.1590581923@sss.pgh.pa.us> <20200528065948.GC3460@paquier.xyz> <6214.1590671660@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="WBsA/oQW3eTA3LlM" Content-Disposition: inline In-Reply-To: <6214.1590671660@sss.pgh.pa.us> 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 --WBsA/oQW3eTA3LlM Content-Type: multipart/mixed; boundary="HWvPVVuAAfuRc6SZ" Content-Disposition: inline --HWvPVVuAAfuRc6SZ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, May 28, 2020 at 09:14:20AM -0400, Tom Lane wrote: > +1, but I'd change the whole sentence. Maybe >=20 > Use the CONCURRENTLY option. See REINDEX, where all the caveats of > this option are explained in detail. Agreed. Here is a patch for 12~. Please let me know if that's fine for you. -- Michael --HWvPVVuAAfuRc6SZ Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="reindexdb-docs.patch" diff --git a/doc/src/sgml/ref/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml index f6c3d9538b..026fd018d9 100644 --- a/doc/src/sgml/ref/reindexdb.sgml +++ b/doc/src/sgml/ref/reindexdb.sgml @@ -122,8 +122,9 @@ PostgreSQL documentation - Use the CONCURRENTLY option. See for further information. + Use the CONCURRENTLY option. See + , where all the caveats of this option + are explained in detail. --HWvPVVuAAfuRc6SZ-- --WBsA/oQW3eTA3LlM Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl7QncMACgkQnvQgOdby QH01FxAAllB/O4YcDdRkMEpnGb1WAucjvdrcDADFRV2Xx2Jp8j2JMCEpvD03sXL/ /HnxBsqRlS83qa/yE0AyBnDfUW/7eT08EwWrMNItaQgue4sJvBxhm90sbWRD/+0w 0f/E7Nx7pKb1SXJ7OITy+ffIKuLTctMb70E+0nnPW6DMK5o+wzy50Xfwq2H/U22q DQYuI2KSdyasduAnycLK5zf0xMTHMPA8dWJUSLg3zobkiUqg5aYLhzQj0oKLW7u/ 8yK+h9GTyKjycZgskYtNVuiu+2VEzQpuEW4vNj6+XBbBdKD6x/g/X08JjZC1qyxv 5h49pBuVJ2+XegBavzl/pEeULR3LDsWfuC4cqyRevKofFPQ3QSwr/ue/SMD5HJx6 /xFuX+rlvT4qUUNG8hWJur4KA5k1IZOuDMpB+DS7bxT7PF+45CvT4mqsT0dGDSVY 58wnyHOireYOwiuG+lqlt2EbTwcxndyOBuQXe0oQGSJ5/Wi44cIV4HF1UAPXNSQn Z6NBDPWYRZA572FLedc/qKmfWsToslOe3AFyyQyG3DfRYxu5hAYlStIReiCS386r 2qb1XfZiWNY2ZmfKyPkawh6chdSAdFqWL/ZtaE4eU2UA0MwR7rI+GrmsvDVTNte2 WihRGbnEMIjvJsG21xlAIPYgZZpFQAI/uWZHtAa2ZGq8b3YtB2g= =7fuo -----END PGP SIGNATURE----- --WBsA/oQW3eTA3LlM--