Re: CLUSTER on partitioned index

Justin Pryzby <pryzby@telsasoft.com>

From: Justin Pryzby <pryzby@telsasoft.com>

To: Michael Paquier <michael@paquier.xyz>

Cc: 李杰(慎追) <adger.lj@alibaba-inc.com>, pgsql-hackers@lists.postgresql.org, 曾文旌(义从) <wenjing.zwj@alibaba-inc.com>, Alvaro Herrera <alvherre@2ndquadrant.com>

Date: 2020-11-05T02:23:56Z

Lists: pgsql-hackers

Attachments

v3-0001-Implement-CLUSTER-of-partitioned-table.patch (text/x-diff)

@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

Commits

Add some isolation tests for CLUSTER
- 21a10368eb3f 15.0 landed
Have CLUSTER ignore partitions not owned by caller
- 3f19e176ae0f 15.0 landed
Remove "recheck" argument from check_index_is_clusterable()
- b940918dc888 15.0 landed
Allow CLUSTER on partitioned tables
- cfdd03f45e6a 15.0 landed
doc: Add backlinks to progress reporting documentation
- 8a8f4d8ede28 14.0 cited