MIME-Version: 1.0
From: sud <suds1434@gmail.com>
Date: Thu, 11 Jul 2024 01:43:31 +0530
Message-ID: <CAD=mzVUGj2Zg0RY9YJwgDzAeghPjuT0FOnNs-aysTBGss87Yyw@mail.gmail.com>
Subject: Dropping column from big table
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000075dd4f061cea481f"
Archived-At: <https://www.postgresql.org/message-id/CAD%3DmzVUGj2Zg0RY9YJwgDzAeghPjuT0FOnNs-aysTBGss87Yyw%40mail.gmail.com>
Precedence: bulk

--00000000000075dd4f061cea481f
Content-Type: text/plain; charset="UTF-8"

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

--00000000000075dd4f061cea481f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi All,<br>It&#39;s postgres database version 15.4. We hav=
e a table which is daily and is approx. ~2TB in size having a total ~90 par=
titions. We have a requirement to drop columns and add new columns to this =
table.=C2=A0<div><br></div><div>I Want to understand, If this can be done o=
nline? what is the fastest way to drop/add columns from such a big table an=
d what will be the consequence of this in regards to vacuum, post this acti=
vity? Or if any other issues we may face post this?<br></div><div><br></div=
><div>Regards</div><div>Sud</div></div>

--00000000000075dd4f061cea481f--