Postgres Pro
Downloads
Home   >   mailing lists

Dropping column from big table - Mailing list pgsql-general

From sud
Subject Dropping column from big table
Date
Msg-id CAD=mzVUGj2Zg0RY9YJwgDzAeghPjuT0FOnNs-aysTBGss87Yyw@mail.gmail.com
Whole thread Raw
Responses Re: Dropping column from big table
List pgsql-general
Tree view
Hi All,
It's postgres database version 15.4. We have a table which is daily and is approx. ~2TB in size having a total ~90 partitions. We have a requirement to drop columns and add new columns to this table. 

I Want to understand, If this can be done online? what is the fastest way to drop/add columns from such a big table and what will be the consequence of this in regards to vacuum, post this activity? Or if any other issues we may face post this?

Regards
Sud

pgsql-general by date:

Previous
From: Olivier Gautherot
Date:
Subject: Re: can stored procedures with computational sql queries improve API performance?
Next
From: Ron Johnson
Date:
Subject: Re: can stored procedures with computational sql queries improve API performance?