Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding Column on Huge Table - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Adding Column on Huge Table
Date
Msg-id CAGDYbUPm_V93DdmDK4wkMyfWUywkefkSkdr0861x3Mb-BAOXZw@mail.gmail.com
Whole thread Raw
In response to Adding Column on Huge Table  (Moin Akther <moindba@hotmail.com>)
List pgsql-admin
Tree view
Hi Moin,

Go through below link hope this will help you.

https://leopard.in.ua/2016/09/20/safe-and-unsafe-operations-postgresql#.XJGan6AzbIU

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Tue, Mar 19, 2019 at 9:26 PM Moin Akther <moindba@hotmail.com> wrote:
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: Thomas Kellerer
Date:
Subject: Re: Adding Column on Huge Table
Next
From: Josef Machytka
Date:
Subject: error: database is not accepting commands to avoid wraparound dataloss in database ....