From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Progress of ALTER TABLE on inheritance-partitioned table?
Date: Fri, 27 Oct 2023 16:04:50 +0200
Message-ID: <c492a7d82d7559cb8e547c161b4d84f2b938fcb0.camel@cybertec.at> (raw)
In-Reply-To: <400b499f-7db5-4e00-ac1c-0b20e855dc88@gmail.com>
References: <400b499f-7db5-4e00-ac1c-0b20e855dc88@gmail.com>
On Fri, 2023-10-27 at 08:34 -0500, Ron wrote:
> Pg 9.6.24 (Yes, I know; it's out of my control.)
>
> I'm ALTERing that table to change a column from INTEGER to BIGINT. Of
> course, all of the partitions are pretty big.
>
> Even though it's one giant transaction, is there any way for me to monitor
> 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
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-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Progress of ALTER TABLE on inheritance-partitioned table?
In-Reply-To: <c492a7d82d7559cb8e547c161b4d84f2b938fcb0.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox