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

From Justin Pryzby
Subject Re: CLUSTER on partitioned index
Date
Msg-id 20220223184732.GN9008@telsasoft.com
Whole thread Raw
In response to CLUSTER on partitioned index  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
On Tue, Jul 20, 2021 at 08:27:02PM -0400, Alvaro Herrera wrote:
> I have to wonder if there really *is* a use case for CLUSTER in the
> first place on regular tables, let alone on partitioned tables, which
> are likely to be large and thus take a lot of time.  What justifies
> spending so much time on this implementation?  My impression is that
> CLUSTER is pretty much a fringe command nowadays, because of the access
> exclusive lock required.
> 
> Does anybody actually use it?

I hope that Alvaro will comment on the simplified patches.  If multiple people
think the patch isn't worth it, feel free to close it.  But I don't see how
complexity could be the reason.

-- 
Justin



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Add index scan progress to pg_stat_progress_vacuum
Next
From: Andrew Dunstan
Date:
Subject: Re: [PATCH] Enable SSL library detection via PQsslAttribute