Re: CLUSTER on partitioned index

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: CLUSTER on partitioned index
Дата
Msg-id 20220223184732.GN9008@telsasoft.com
обсуждение исходный текст
Ответ на CLUSTER on partitioned index  (Justin Pryzby <pryzby@telsasoft.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Add index scan progress to pg_stat_progress_vacuum
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [PATCH] Enable SSL library detection via PQsslAttribute