Re: Physical column size

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Physical column size
Дата
Msg-id
420.1141397627@sss.pgh.pa.us
Ответ на
Re: Physical column size (Peter Eisentraut)
Список
Дерево обсуждения
Re: Physical column size Ragnar <gnari@hive.is>
Peter Eisentraut  writes:
> An int4 field is required to be aligned at a 4-byte boundary internally, so 
> there are 3 bytes wasted between tmp_A.c and tmp_A.i.  If you switch the 
> order of the fields you should see space savings.

Probably not, because the row-as-a-whole has alignment requirements too.
In this example you'll just move the pad bytes from one place to
another.

			regards, tom lane
В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: Just Someone
Дата:
FAQ