Re: DROP column: documentation unclear

Поиск
Список
Период
Сортировка
От Harald Fuchs
Тема Re: DROP column: documentation unclear
Дата
Msg-id puaauhsnad.fsf@srv.protecting.net
обсуждение исходный текст
Ответ на DROP column: documentation unclear  (Adrian von Bidder <avbidder@fortytwo.ch>)
Ответы Re: DROP column: documentation unclear  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
In article <20100308213549.GB660@svana.org>,
Martijn van Oosterhout <kleptog@svana.org> writes:

>> "subsequent ... will store a null value" would imply that deleted columns
>> will still take some place, while "the space will be reclaimed ..." would
>> suggest that new rows (insert or updates in mvcc) don't have the deleted
>> column anymore - I'm not quite sure how to interpret this.  What is pg
>> doing?

> What you're missing is that in postgres NULLs are stored as a bit in
> the header and there is no data. So in a sense NULLs take no space
> (well, one bit) which means both statements are true.

But if you already have eight nullable columns, the (maybe originally
non-null) column which has been dropped would cause the header to be
one byte larger, wouldn't it?

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: \copy command: how to define a tab character as the delimiter
Следующее
От: Tom Lane
Дата:
Сообщение: Re: \copy command: how to define a tab character as the delimiter