Re: CLUSTER progress: wrong index_rebuild_count for tables with TOAST - Mailing list pgsql-hackers

From Antonin Houska
Subject Re: CLUSTER progress: wrong index_rebuild_count for tables with TOAST
Date
Msg-id 78277.1782487433@localhost
Whole thread
In response to CLUSTER progress: wrong index_rebuild_count for tables with TOAST  (Adam Lee <adam8157@gmail.com>)
List pgsql-hackers
Adam Lee <adam8157@gmail.com> wrote:

> The reason is that make_new_heap() creates the new TOAST table, and its
> TOAST index, before the heap is scanned. Building that index reports
> CREATE INDEX progress. CREATE INDEX and the cluster command use the same
> progress field for different things, so the cluster command then shows a
> CREATE INDEX value as its index_rebuild_count.

I'd prefer enhanced progress monitoring that I proposed earlier [1]. The patch
needs more work, I'll try to submit it for the next development cycle.

[1] https://www.postgresql.org/message-id/30939.1777888333%40localhost

-- 
Antonin Houska
Web: https://www.cybertec-postgresql.com



pgsql-hackers by date:

Previous
From: Dmitry Koval
Date:
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Next
From: Peter Geoghegan
Date:
Subject: Re: [GSoC 2026] - B-tree Index Bloat Reduction - Approach & Questions