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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux