agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Antonin Houska <ah@cybertec.at>
To: Adam Lee <adam8157@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Cc: alvherre@kurilemu.de
Subject: Re: CLUSTER progress: wrong index_rebuild_count for tables with TOAST
Date: Fri, 26 Jun 2026 17:23:53 +0200
Message-ID: <78277.1782487433@localhost> (raw)
In-Reply-To: <aj4gJQMba0kClQmj@Mac>
References: <aj4gJQMba0kClQmj@Mac>
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
view thread (6+ messages) latest in thread
Message-ID: <78277.1782487433@localhost>
Permalink: ../78277.1782487433@localhost/
Also on: postgresql.org/message-id/78277.1782487433@localhost
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: ah@cybertec.at, adam8157@gmail.com, pgsql-hackers@lists.postgresql.org, alvherre@kurilemu.de
Subject: Re: CLUSTER progress: wrong index_rebuild_count for tables with TOAST
In-Reply-To: <78277.1782487433@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox