Determine potential change in table size after a column dropped?

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Determine potential change in table size after a column dropped?
Дата
Msg-id CAOC+FBWMDP4DOPEYMZH6ZS6EzKV8_twSSebGwD2eLUcEK+i4yg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Determine potential change in table size after a column dropped?
Список 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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Gauging progress of COPY?
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: Determine potential change in table size after a column dropped?