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 1kFnoM-0006jR-Mp for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Sep 2020 00:18:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kFnoK-0000W8-BW for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Sep 2020 00:18:04 +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 1kFnoK-0000W1-57 for pgsql-hackers@lists.postgresql.org; Wed, 09 Sep 2020 00:18:04 +0000 Received: from mail-io1-xd42.google.com ([2607:f8b0:4864:20::d42]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kFnoH-0004v0-LI for pgsql-hackers@lists.postgresql.org; Wed, 09 Sep 2020 00:18:02 +0000 Received: by mail-io1-xd42.google.com with SMTP id b6so1322338iof.6 for ; Tue, 08 Sep 2020 17:18:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=1SLbS/wfRaVGTUYFKso2tjFCO0Pcp1+rtmb+Dr6V57E=; b=cb76MoDKBJEw/r3GErkQrAQXOxOrVVWiydC05nZvWilBmwn475jVDL+Ep2jZ0NNKbt htGNlhA3WV2opVjspDCU9qI8Wsof82sgWXqT1h8KCXID+rmPstcbk28Ox2wOCvwQYYfN IwJFp2yVSfydmjuWiwe0bIwt96qOduLyjxilaHb8hq+D1+qtHNpJYPxEUJzmrjjcElGB d555fLiO/XS5LSI4InGeSixbyDzBD5I+GEFEmPehXpBhg5L0QNaO7smI8a3RjgtGTft3 iFghdyo77nIEZaAls5nDIrlRzVGhhQxo/a41VBh1/eV7V80ca9v5x65qetU1Foc1xdSQ Z13g== 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:references :mime-version:content-disposition:in-reply-to:user-agent; bh=1SLbS/wfRaVGTUYFKso2tjFCO0Pcp1+rtmb+Dr6V57E=; b=a6fUSJqBfhQHEQ5cdLDJFyPZLuP2aHcbKz5P61+a0O7wTGvMYebk/H7l1AF5F5MXiY +sV3iujFnYV9higg6c8INQlHqkJZlvIxzuq2e7h2o0frjkuKH13ST0eS/Q69uAYZLFSk myqCnqkNtkZwGpnfrxr7NuW9yiEpT37qMabnvKmJnhyv3dVD1CecBhS7VJa5+yBMD6lC PxFWvzNSD5URhBmJvcoHyZ7VX2j9t65Bnb1Ui66RqJjVt3S/DUIHeinmvtYlRBWHRS5z OpbaZ3FDxHxheSjLPWYxfcuEU23SVTWBek8hcDPCZjryVxzLBjlpoB1gFarzlwtZM5gp wGkA== X-Gm-Message-State: AOAM5339qwntWZ/mUbFdK2fzQJC+Vv1fP4HzJjmjkEFVzFespG9zMwcs +0zOJ9f23QDpGcQoOCOBZadKfQ== X-Google-Smtp-Source: ABdhPJwuvLrGKW2AUdA0Kta9P0PwIyyNja8Vr1l/nlWHPleQGd1UR0G8T6jvlixIspQHh34/tdYL6w== X-Received: by 2002:a5d:9a15:: with SMTP id s21mr1314657iol.141.1599610680903; Tue, 08 Sep 2020 17:18:00 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id d20sm431332iof.44.2020.09.08.17.17.59 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 08 Sep 2020 17:18:00 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 1B8958004A5; Tue, 8 Sep 2020 19:17:58 -0500 (CDT) Date: Tue, 8 Sep 2020 19:17:58 -0500 From: Justin Pryzby To: Alvaro Herrera Cc: Alexey Kondratov , Michael Paquier , 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: <20200909001757.GD18552@telsasoft.com> References: <20200908233951.GC18552@telsasoft.com> <20200909000238.GA1563@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200909000238.GA1563@alvherre.pgsql> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, Sep 08, 2020 at 09:02:38PM -0300, Alvaro Herrera wrote: > On 2020-Sep-08, Justin Pryzby wrote: > > > From 992e0121925c74d5c5a4e5b132cddb3d6b31da86 Mon Sep 17 00:00:00 2001 > > From: Justin Pryzby > > Date: Fri, 27 Mar 2020 17:50:46 -0500 > > Subject: [PATCH v27 1/5] Change REINDEX/CLUSTER to accept an option list.. > > > > ..like EXPLAIN (..), VACUUM (..), and ANALYZE (..). > > > > Change docs in the style of VACUUM. See also: 52dcfda48778d16683c64ca4372299a099a15b96 > > I don't understand why you change all options to DefElem instead of > keeping the bitmask for those options that can use it. That's originally how I did it, too. Initially I added List *params, and Michael suggested to retire ReindexStmt->concurrent. I provided a patch to do so, initially by leaving int options and then, after this, removing it to "complete the thought", and get rid of the remnants of the "old way" of doing it. This is also how vacuum and explain are done. https://www.postgresql.org/message-id/20200902022410.GA20149%40telsasoft.com -- Justin