Fri, 07 Jul 2023 15:24:22 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/online-data-type-change-in-postgresql/ https://www.percona.com/blog/online-data-type-change-in-postgresql/#respond Fri, 07 Jul 2023 15:24:22 +0000 https://www.percona.com/blog/?p=89274 Changing the data type on a column in a big table is almost always a pain. It can lock out the entire table for reading and writing because of the exclusive lock acquired by the ALTER TABLE statement that changes the data type. In this blog post, we will look at one possibility of performing […]]]> https://www.percona.com/blog/online-data-type-change-in-postgresql/feed/ 0 89274