Postgres Pro
Downloads
Home   >   mailing lists

Re: Alter the column data type of the large data volume table. - Mailing list pgsql-general

From Rich Shepard
Subject Re: Alter the column data type of the large data volume table.
Date
Msg-id alpine.LNX.2.20.2012030927230.29996@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Alter the column data type of the large data volume table.  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Alter the column data type of the large data volume table.
Next
From: Ron
Date:
Subject: Re: Alter the column data type of the large data volume table.