Re: CLUSTER on partitioned index - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: CLUSTER on partitioned index
Date
Msg-id YmeAV6gG/7Xqhiba@paquier.xyz
Whole thread Raw
In response to CLUSTER on partitioned index  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: CLUSTER on partitioned index  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
On Sat, Apr 16, 2022 at 08:58:50PM +0900, Michael Paquier wrote:
> Well, I am a bit annoyed that we don't actually check that a CLUSTER
> command does not block when doing a CLUSTER on a partitioned table
> while a lock is held on one of its partitions.  So, attached is a
> proposal of patch to improve the test coverage in this area.  While on
> it, I have added a test with a normal table.  You can see the
> difference once you remove the ACL check added recently in
> get_tables_to_cluster_partitioned().  What do you think?

This was the last reason why this was listed as an open item, so,
hearing nothing, I have applied this patch to add those extra tests,
and switched the item as fixed.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pgsql: Add contrib/pg_walinspect.
Next
From: David Rowley
Date:
Subject: Re: Making JIT more granular