Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>, Steve Singer <steve(at)ssinger(dot)info>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Robert Haas <robertmhaas(at)gmail(dot)com>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Jose Luis Tallon <jltallon(at)adv-solutions(dot)net>
Subject: Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly
Date: 2020-09-08 23:39:51
Message-ID: 20200908233951.GC18552@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Sep 03, 2020 at 09:43:51PM -0500, Justin Pryzby wrote:
> And rebased on Michael's commit removing ReindexStmt->concurrent.

Rebased on a6642b3ae: Add support for partitioned tables and indexes in REINDEX

So now this includes the new functionality and test for reindexing a
partitioned table onto a new tablespace. That part could use some additional
review.

I guess this patch series will also conflict with the CLUSTER part of this
other one. Once its CLUSTER patch is commited, this patch should to be updated
to test clustering a partitioned table to a new tbspc.
https://commitfest.postgresql.org/29/2584/
REINDEX/CIC/CLUSTER of partitioned tables

--
Justin

Attachment Content-Type Size
v27-0001-Change-REINDEX-CLUSTER-to-accept-an-option-list.patch text/x-diff 18.5 KB
v27-0002-Allow-REINDEX-to-change-tablespace.patch text/x-diff 36.5 KB
v27-0003-Allow-CLUSTER-and-VACUUM-FULL-to-change-tablespa.patch text/x-diff 23.5 KB
v27-0004-Implement-vacuum-full-cluster-INDEX_TABLESPACE-t.patch text/x-diff 19.0 KB
v27-0005-Refactor-gram.y-in-order-to-add-a-common-parenth.patch text/x-diff 5.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Fan 2020-09-08 23:51:12 Re: [PATCH] Keeps tracking the uniqueness with UniqueKey
Previous Message Tomas Vondra 2020-09-08 23:16:27 Re: WIP: WAL prefetch (another approach)