Re: Alter the column data type of the large data volume table.

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Alter the column data type of the large data volume table.
Date: 2020-12-03 17:27:51
Message-ID: alpine.LNX.2.20.2012030927230.29996@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 3 Dec 2020, Michael Lewis wrote:

> Afaik, it will require an access exclusive lock for the entire time it
> takes to re-write the 1.6 billion rows and update all indexes. That sort
> of lock out time doesn't seem workable in many production systems.

Michael,

Okay. I hadn't thought of that.

Stay well,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2020-12-03 17:50:54 Re: Alter the column data type of the large data volume table.
Previous Message Michael Lewis 2020-12-03 17:26:08 Re: Alter the column data type of the large data volume table.