Moin Akther wrote: > We want to add a column on table size of 1.5TB, we have to perform this activity with minimal downtime. > > What are the best practises to add a column on huge table ? > > How much time alter statement will take to add column ? > > Any alternate solution other than alter statement to add column ? > > Will adding a new column on a huge table generate huge WAL files ? As a quick experiment would have told you, adding a column without a DEFAULT clause is very fast. Since v11, it is fast even if the new column has a DEFAULT clause. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
