Adding Column on Huge Table - Mailing list pgsql-admin

From Moin Akther
Subject Adding Column on Huge Table
Date
Msg-id HK0PR03MB2977B9460C4CC7D0383D05BDAD400@HK0PR03MB2977.apcprd03.prod.outlook.com
Whole thread Raw
Responses Re: Adding Column on Huge Table  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Adding Column on Huge Table  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
Dear Experts,

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 ?

Thanks and Best Regards,

Akther


pgsql-admin by date:

Previous
From: "Mark Williams"
Date:
Subject: FW: PostgreSQL SSL specifying certificate paths
Next
From: Aliza Abulafia
Date:
Subject: PostgreSQL high availability solutions for high rates.