Search Postgresql Archives

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

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

Subject: Re: Alter the column data type of the large data volume table.
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Thu, 3 Dec 2020 09:27:51 -0800 (PST)
In-reply-to: <CAHOFxGpL=DVjXkAagAJjA7XeVm0gSd+vFnw979us5-RBaG+B1Q@mail.gmail.com>
References: <CAD5cqMJT9Q=U3EkpgjsL5QcHNXfwvHVHe+RBabZBXh4OW9n8AA@mail.gmail.com> <CAHOFxGpqi_=T2JQf+eNef3A5XR-Z9FeSB-hpZkG5aOr0PPvi0g@mail.gmail.com> <alpine.LNX.2.20.2012030915280.29996@salmo.appl-ecosys.com> <CAHOFxGpL=DVjXkAagAJjA7XeVm0gSd+vFnw979us5-RBaG+B1Q@mail.gmail.com>
User-agent: Alpine 2.20 (LNX 67 2015-01-07)

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

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

References:
- Alter the column data type of the large data volume table.
  - From: charles meng
- Re: Alter the column data type of the large data volume table.
  - From: Michael Lewis
- Re: Alter the column data type of the large data volume table.
  - From: Rich Shepard
- Re: Alter the column data type of the large data volume table.
  - From: Michael Lewis

Prev by Date: Re: Alter the column data type of the large data volume table.
Next by Date: Re: Alter the column data type of the large data volume table.
Previous by thread: Re: Alter the column data type of the large data volume table.
Next by thread: Re: Alter the column data type of the large data volume table.
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]