Re: CLUSTER on partitioned index

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: 李杰(慎追) <adger(dot)lj(at)alibaba-inc(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, 曾文旌(义从) <wenjing(dot)zwj(at)alibaba-inc(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject: Re: CLUSTER on partitioned index
Date: 2020-11-05 02:23:56
Message-ID: 20201105022356.GX22691@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

@cfbot: rebased

On Tue, Oct 27, 2020 at 07:33:12PM -0500, Justin Pryzby wrote:
> I'm attaching a counter-proposal to your catalog change, which preserves
> indisclustered on children of clustered, partitioned indexes, and invalidates
> indisclustered when attaching unclustered indexes.

..and now propagates CLUSTER ON to child indexes.

I left this as separate patches to show what I mean and what's new while we
discuss it.

--
Justin

Attachment Content-Type Size
v3-0001-Implement-CLUSTER-of-partitioned-table.patch text/x-diff 16.6 KB
v3-0002-preserve-indisclustered-on-children-of-clustered-.patch text/x-diff 2.9 KB
v3-0003-Propogate-changes-to-indisclustered-to-child-pare.patch text/x-diff 10.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Euler Taveira 2020-11-05 02:25:01 Re: Log message for GSS connection is missing once connection authorization is successful.
Previous Message Kyotaro Horiguchi 2020-11-05 02:18:42 Re: Some doubious code in pgstat.c