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 1kjyRX-0005SO-US for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Dec 2020 05:43: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 1kjyRW-00089d-Rv for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Dec 2020 05:43:14 +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 1kjyRW-00089W-Fe for pgsql-hackers@lists.postgresql.org; Tue, 01 Dec 2020 05:43:14 +0000 Received: from mail-il1-x12a.google.com ([2607:f8b0:4864:20::12a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kjyRT-0002ig-V0 for pgsql-hackers@lists.postgresql.org; Tue, 01 Dec 2020 05:43:14 +0000 Received: by mail-il1-x12a.google.com with SMTP id w8so494532ilg.12 for ; Mon, 30 Nov 2020 21:43:11 -0800 (PST) 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=P1OL4ZuTDAyzpvw/+THVZB3eGOyUG8nATdbx5WmgGsA=; b=axsgtOKtdULt6DtBGLw3xljMn99IMIa58Itw/1263tdqAwgqrGwlPDpTxe3SnUkVXk DHFDioOBBH4nl/oc0etYyivCr5PfR06bP+47mPSpeRqeZ2mxxq+7gshYluBZ2VtI+5AL Ro1E0bxDszSP2kWOztrEaAAWOoSQk/Aj3usjAndDvMt+nI+KFRI5rdfgQtJXdK6hGh83 Eh8dCloVOef53M063YdOLn09tP7OAgEberXhglPyWzkE4biKAqY6IJ4XwVHZsm2KFRRU 22l6RmKsnRaJ72rRUdj/8vokMsAqafAwJrHNtTxx9qXqifJHnbwXOgYpplvOKNwb3O1N QdOQ== 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=P1OL4ZuTDAyzpvw/+THVZB3eGOyUG8nATdbx5WmgGsA=; b=LSFw1JXnkZSGWAnzjciblXNnKPIfUl3CxCXHZLFWoQt3snxNyzy6cP2i3IlKOuFOw1 O4rb4sMyqO0UwxGkmGPeFvuBXkP6gIlWuIKkjxOqBc2KdBjA7oJQtjwJiIU0+c+IHWTC BQ8LID6+ntNYzkiZf59KMFUlnVcZp9DediyR2eI2Zuv6kA/7M8w1cnViKXQsC342wvAx SWVqzBjsNpLzcYSuf52xyRYso1MKWc8vbl1t1UZr34qQo35nNSsYWsgQyxvRGyowtgB8 ksfIuD/yep2err5NWPS29zThogFJ+44Wq9Z5iE8Ip361BSuvBY3OadVDoFd3deYyuvao D0Ig== X-Gm-Message-State: AOAM530Eu7dLlyzCobHgJllMda5E6pceOdlhnQ7HZShYZMU6fFu9bTfz H2vsg4c93pR1fe57pyYJytoZ9w== X-Google-Smtp-Source: ABdhPJwUsxvGZf8moivxvS2qTudo9nuA4hwqhXo9eGBTjvlXtL+JPRJcGC4ZUu9JpGLNN7WTUaa+kA== X-Received: by 2002:a05:6e02:662:: with SMTP id l2mr1034679ilt.182.1606801390261; Mon, 30 Nov 2020 21:43:10 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id h1sm455068ilj.8.2020.11.30.21.43.09 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 30 Nov 2020 21:43:09 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 33B2D800CE0; Mon, 30 Nov 2020 23:43:08 -0600 (CST) Date: Mon, 30 Nov 2020 23:43:08 -0600 From: Justin Pryzby To: Michael Paquier Cc: Alexey Kondratov , Alvaro Herrera , 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: <20201201054308.GC24052@telsasoft.com> References: <20200909000238.GA1563@alvherre.pgsql> <20200909001757.GD18552@telsasoft.com> <20200909122200.GA2743@paquier.xyz> <20200909153629.GG18552@telsasoft.com> <20201031183611.GA22691@telsasoft.com> <20201124153123.GO24052@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: 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, Dec 01, 2020 at 11:46:55AM +0900, Michael Paquier wrote: > On Mon, Nov 30, 2020 at 05:12:42PM +0300, Alexey Kondratov wrote: > > Thanks. I have rebased the remaining patches on top of 873ea9ee to use > > 'utility_option_list' instead of 'common_option_list'. > > Thanks, that helps a lot. I have gone through 0002, and tweaked it as > the attached (note that this patch is also interesting for another > thing in development: backend-side reindex filtering of > collation-sensitive indexes). Does that look right to you? I eyeballed the patch and rebased the rest of the series on top if it to play with. Looks fine - thanks. FYI, the commit messages have the proper "author" for attribution. I proposed and implemented the grammar changes in 0002, and implemented INDEX_TABLESPACE, but I'm a reviewer for the main patches. -- Justin