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 1gjpTY-0006dV-I7 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Jan 2019 17:59:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjpTW-0007Qa-8X for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Jan 2019 17:59:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjpTV-0007QN-Ps for pgsql-hackers@lists.postgresql.org; Wed, 16 Jan 2019 17:59:38 +0000 Received: from mail-qt1-x843.google.com ([2607:f8b0:4864:20::843]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjpTS-0001Mi-Py for pgsql-hackers@postgresql.org; Wed, 16 Jan 2019 17:59:36 +0000 Received: by mail-qt1-x843.google.com with SMTP id k12so8176357qtf.7 for ; Wed, 16 Jan 2019 09:59:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=HXHPgn0o2Nl0IBV3KMBBZ9vbN7/43ehVlSiunF/os0M=; b=djjXww3gIJSV95L+c/VGffBUchUKdLIuipQecin9YITzmsqIVgbEaCXMiyOkOucqZU ATIXKfYAXmttUPEAKIcI+3363ai8EAkRnzzc0XwstQX3kwEe91qRR0/RDK+yCu/5uqLk R47Mx1wfH1eYyLixnrUvj5hEkQzB2e+DvVRj7zixFBHrZgE7Zva3jSCnhBtoMPJwuboQ ost6qxCROeq9t75wBaJByvDNDVfbnfZxHFLYwlQ7UEFH9/Ny+zn6bmtg0drXeAyOrda1 6y3KrOfsqlR9eIS+ru/PRJ5teWy3c+GrYS2QtHVfPrONQ8QnAxfGlUiSacrvI8ERdWrB BsXQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=HXHPgn0o2Nl0IBV3KMBBZ9vbN7/43ehVlSiunF/os0M=; b=gvPpC3xlb5OXFxBXzfFPN/NR2JIFMiFPNKpScxlbIle4g+DUNEFVIDsMtgX2vwjrg4 H2XMlrHq7pMoJbpDsdhFr5tsK/cuVIuVAfFcXBAf2i0Ke6E9wQyxAtK9dC0akKK2bNeg wFSgeScitWxjL9B/B/Y2W1/0eW7Se3JjubvsdvS0uxI67UrrEd7M3+a2ChH8y4fU1VX4 6fH+M1aBxEGB5wJ2C4styG46DVaOoOmIDFMeoHbwbTgm0N/e2k/lM6iXuQCvPbdq7z5v QnXec8XuUKGd0wpIifvctHxk7JQwOOiZ1StxAYJV0K7W/yXkveNx9v79IJqjgAJqea7+ zZ1A== X-Gm-Message-State: AJcUukf8XwDNbcCwC95e3xRBrrjuZ6g02c77AX7NW9BQGIB3jaTx5AEn oyifVkyiQ5AuOn+1Oe5vxmCdBQ== X-Google-Smtp-Source: ALg8bN74bfRZ2dmqwTDWhxQbOd7Nr+uZXMpUpwHGJY4q/4N/Tnop6qDUTgX9rbv3tqWNbwUHYwGiUQ== X-Received: by 2002:aed:3a69:: with SMTP id n96mr8189955qte.246.1547661573843; Wed, 16 Jan 2019 09:59:33 -0800 (PST) Received: from alvin.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id d7sm22456783qkk.71.2019.01.16.09.59.33 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Wed, 16 Jan 2019 09:59:33 -0800 (PST) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 3AA0829D; Wed, 16 Jan 2019 14:59:31 -0300 (-03) Date: Wed, 16 Jan 2019 14:59:31 -0300 From: Alvaro Herrera To: Michael Paquier Cc: Sergei Kornilov , Peter Eisentraut , Michael Paquier , Andreas Karlsson , PostgreSQL mailing lists , Stephen Frost , Craig Ringer Subject: Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Message-ID: <201901161759.voovsk55ofe7@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20190116082705.GB2550@paquier.xyz> User-Agent: NeoMutt/20180716-1013-2c1e88 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-Jan-16, 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. That's my opinion too, but I was outvoted in another subthread -- see https://postgr.es/m/20181214144529.wvmjwmy7wxgmgyb3@alvherre.pgsql Stephen Frost, Andrew Gierth and Andres Freund all voted to put CONCURRENTLY outside the parens. It seems we now have three votes to put it *in* the parens (you, Peter Eisentraut, me). I guess more votes are needed to settle this issue. My opinion is that if we had had parenthesized options lists back when CREATE INDEX CONCURRENTLY was invented, we would have put it there. But we were young and needed the money ... -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services