Re: Adding Column on Huge Table

Поиск
Список
Период
Сортировка
От Shreeyansh Dba
Тема Re: Adding Column on Huge Table
Дата
Msg-id CAGDYbUPm_V93DdmDK4wkMyfWUywkefkSkdr0861x3Mb-BAOXZw@mail.gmail.com
обсуждение исходный текст
Ответ на Adding Column on Huge Table  (Moin Akther <moindba@hotmail.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления: