Re: Progress of ALTER TABLE on inheritance-partitioned table?

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Progress of ALTER TABLE on inheritance-partitioned table?
Date: 2023-10-27 14:04:50
Message-ID: c492a7d82d7559cb8e547c161b4d84f2b938fcb0.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Loles 2023-10-27 14:16:09 ORDER BY DESC and NULLS LAST by default
Previous Message Rozad Khalaf 2023-10-27 13:42:37 Introducing PostgresFly: A New PostgreSQL Installation Tool