Determine potential change in table size after a column dropped? - Mailing list pgsql-admin

From Wells Oliver
Subject Determine potential change in table size after a column dropped?
Date
Msg-id CAOC+FBWMDP4DOPEYMZH6ZS6EzKV8_twSSebGwD2eLUcEK+i4yg@mail.gmail.com
Whole thread Raw
Responses Re: Determine potential change in table size after a column dropped?  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
List pgsql-admin
I have a large large large table with many many many rows, and it's a certain size in pg_relation_size -- there's a timestamp with tz column on this table that's mostly kind of useless, and I want to figure out how much space it would free if we just dropped it. Can I easily do this?

I can fire up a replica and drop the column there and compare but that takes some time, so wondering if there's some simple math here due to an inherent tz timestamp column size, or something.

Thanks.

--

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Gauging progress of COPY?
Next
From: Vijaykumar Jain
Date:
Subject: Re: Determine potential change in table size after a column dropped?