Adding Column on Huge Table

From: Moin Akther <moindba(at)hotmail(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Adding Column on Huge Table
Date: 2019-03-19 15:56:20
Message-ID: HK0PR03MB2977B9460C4CC7D0383D05BDAD400@HK0PR03MB2977.apcprd03.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Aliza Abulafia 2019-03-19 16:04:11 PostgreSQL high availability solutions for high rates.
Previous Message Mark Williams 2019-03-18 18:14:45 FW: PostgreSQL SSL specifying certificate paths