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 1kD8WV-0007uy-Ak for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Sep 2020 15:48:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kD8WU-000852-8J for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Sep 2020 15:48:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kD8WU-00084v-1Y for pgsql-hackers@lists.postgresql.org; Tue, 01 Sep 2020 15:48:38 +0000 Received: from mail-qt1-x842.google.com ([2607:f8b0:4864:20::842]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kD8WR-00071M-JP for pgsql-hackers@lists.postgresql.org; Tue, 01 Sep 2020 15:48:37 +0000 Received: by mail-qt1-x842.google.com with SMTP id e5so1244792qth.5 for ; Tue, 01 Sep 2020 08:48:35 -0700 (PDT) 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=vn/Fhb6x5codnsyjiYg1CdpWBCQ1UPg56A4chZb9XEI=; b=AcoPyjV/yJIXhk8YBm/2ILdnrCiNqo3RpzWspQsHZ5g1/2LF7Sq9SqBgSGFCgLB1sU NCzi0HkrFDmDgDONq53zv82Sn09SeSM0tw8/0M+/fvnkS07eJ7D6+czGAWa3+k9eRreD PaEC2hCnqtItbaUyILyZ4ziO9pQhMInkEf0MtSos9YdItrFv++4Po1jH0G92bDDtcIR3 06uN8k5AqpzLS7PPgGFRBxNETGOSXxSXPwVriRjfnU8lfZKKUfEpEy7Q9y/QpNuMMVOA xo6YxE/6+e9TjNz/++/o8qrhpUYXQyV2jNLVqlXW1elwOTn2RlGdo6PJnd+yCIpr5VIe wQIw== 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=vn/Fhb6x5codnsyjiYg1CdpWBCQ1UPg56A4chZb9XEI=; b=IQZFdu0BMhiLTUdmiUh5mtSTzxCDkRqnQLLLTK+Nl05f6uhixaFXnr12laWVG7x1rc 8EvF+EMiD7gJ+mQxXYpiqCXWDXIsUnt8I0b+O5WqTD6yzRpUnPRPwOmcP1OOTh8fTmCn rjkEOFvZgyrWX8wJ1IgyNdhWCbW26NnmRhCTJykA1VPv1a8RC8kYODbbJKyFG0KEftRS mc45ZY4hIB1msaIzPUErLgujPb5BcdiMmVHgaptqcvQmp7O4IrqU5YCcfZHsLutIHUaU C72/gh8BEZxn1pPdeWKGfvoKCV4V6giYBrahafwPKAYtYCykqm90E51awUdfBk7zsfun xQyg== X-Gm-Message-State: AOAM5311MfMKG7DxkqS8oAjJ3npOb3U/CDS2BoKYXeX+XM9SsE4tkLKb nL7+ayMNtY/tvqnS4yfekPu2Lw== X-Google-Smtp-Source: ABdhPJyNseO0skh6r1HakvTkk44Rz598RrRQ1cxje5k38W3++FtC5izvgJKSB/BX5CFnBRR000DJEg== X-Received: by 2002:ac8:34f2:: with SMTP id x47mr2439873qtb.282.1598975313512; Tue, 01 Sep 2020 08:48:33 -0700 (PDT) Received: from perhan.alvh.no-ip.org ([190.95.19.47]) by smtp.gmail.com with ESMTPSA id x59sm1880573qte.14.2020.09.01.08.48.32 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 01 Sep 2020 08:48:32 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id E65D62A1557; Tue, 1 Sep 2020 11:48:30 -0400 (-04) Date: Tue, 1 Sep 2020 11:48:30 -0400 From: Alvaro Herrera To: Justin Pryzby Cc: Michael Paquier , Alexey Kondratov , Masahiko Sawada , Steve Singer , pgsql-hackers@lists.postgresql.org, Robert Haas , Alexander Korotkov , Masahiko Sawada , Jose Luis Tallon Subject: Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Message-ID: <20200901154830.GA8891@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20200901154354.GD5450@telsasoft.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-Sep-01, Justin Pryzby wrote: > On Tue, Sep 01, 2020 at 11:40:18AM -0400, Alvaro Herrera wrote: > > The advantage of using a parenthesized option list is that you can add > > *further* options without making the new keywords reserved. Of course, > > we already reserve CONCURRENTLY and VERBOSE pretty severely, so there's > > no change. If you wanted REINDEX FLUFFY then it wouldn't work without > > making that at least type_func_name_keyword I think; but REINDEX > > (FLUFFY) would work just fine. And of course the new feature at hand > > can be implemented. > > The question isn't whether to use a parenthesized option list. I realized that > long ago (even though Alexey didn't initially like it). Check 0002, which gets > rid of "bool concurrent" in favour of stmt->options&REINDEXOPT_CONCURRENT. Ah! I see, sorry for the noise. Well, respectfully, having a separate boolean to store one option when you already have a bitmask for options is silly. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services