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