Message-ID: <c492a7d82d7559cb8e547c161b4d84f2b938fcb0.camel@cybertec.at>
Subject: Re: Progress of ALTER TABLE on inheritance-partitioned table?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ron <ronljohnsonjr@gmail.com>, pgsql-admin@lists.postgresql.org
Date: Fri, 27 Oct 2023 16:04:50 +0200
In-Reply-To: <400b499f-7db5-4e00-ac1c-0b20e855dc88@gmail.com>
References: <400b499f-7db5-4e00-ac1c-0b20e855dc88@gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/c492a7d82d7559cb8e547c161b4d84f2b938fcb0.camel%40cybertec.at>
Precedence: bulk

On Fri, 2023-10-27 at 08:34 -0500, Ron wrote:
> Pg 9.6.24 (Yes, I know; it's out of my control.)
>=20
> I'm ALTERing that table to change a column from INTEGER to BIGINT. Of=20
> course, all of the partitions are pretty big.
>=20
> Even though it's one giant transaction, is there any way for me to monito=
r=20
> it's progress?

No, there is no way to monitor progress.  The best you can do is to follow
the growth of the table on disk.

You could consider logical replication ... oh, wait, 9.6.

Yours,
Laurenz Albe