Re: CLUSTER progress: wrong index_rebuild_count for tables with TOAST

Antonin Houska <ah@cybertec.at>

From: Antonin Houska <ah@cybertec.at>
To: Adam Lee <adam8157@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org, alvherre@kurilemu.de
Date: 2026-06-26T15:23:53Z
Lists: 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