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 1gjoVK-0003oF-Uo for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Jan 2019 16:57:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjoUK-0008Ug-52 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Jan 2019 16:56:24 +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 1gjoUJ-0008UZ-UG for pgsql-hackers@lists.postgresql.org; Wed, 16 Jan 2019 16:56:23 +0000 Received: from kilimanjaro.scorpionshops.com ([82.118.24.85]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjoUD-0001XL-Qc for pgsql-hackers@postgresql.org; Wed, 16 Jan 2019 16:56:23 +0000 Received: from [192.168.1.168] (c-8352e253.143-1-64736c10.bbcust.telenor.se [83.226.82.131]) by kilimanjaro.scorpionshops.com (Postfix) with ESMTPSA id E87AD7BC81F; Wed, 16 Jan 2019 17:56:15 +0100 (CET) Subject: Re: [HACKERS] REINDEX CONCURRENTLY 2.0 To: Michael Paquier , Sergei Kornilov Cc: Peter Eisentraut , Michael Paquier , PostgreSQL mailing lists , Stephen Frost , Craig Ringer , Alvaro Herrera References: <20180126022813.GD2416@tamriel.snowman.net> <9523ad05-525c-598e-ad2d-061b5a94062c@proxel.se> <20180201062158.GD6398@paquier.xyz> <60052986-956b-4478-45ed-8bd119e9b9cf@2ndquadrant.com> <10797471544200851@myt3-964eae3a5b05.qloud-c.yandex.net> <93a3d2fb-43a0-cf14-e8d0-d2c3195c1e5b@2ndquadrant.com> <20486991544381729@iva5-d3020dc3459d.qloud-c.yandex.net> <36712441546604286@sas1-890ba5c2334a.qloud-c.yandex.net> <20190116082705.GB2550@paquier.xyz> From: Andreas Karlsson Message-ID: Date: Wed, 16 Jan 2019 17:56:15 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.4.0 MIME-Version: 1.0 In-Reply-To: <20190116082705.GB2550@paquier.xyz> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 1/16/19 9:27 AM, Michael Paquier wrote:> Regarding the grammar, we tend for the last couple of years to avoid > complicating the main grammar and move on to parenthesized grammars > (see VACUUM, ANALYZE, EXPLAIN, etc). So in the same vein I think that > it would make sense to only support CONCURRENTLY within parenthesis > and just plugin that with the VERBOSE option. Personally I do not care, but there have been a lot of voices for keeping REINDEX CONCURRENTLY consistent with CREATE INDEX CONCURRENTLY and DROP INDEX CONCURRENTLY. > Does somebody mind if I jump into the ship after so long? I was the > original author of the monster after all... Fine by me. Peter? Andreas