Re: Physical column size

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Physical column size
Дата
Msg-id 420.1141397627@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Physical column size  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
Peter Eisentraut <peter_e@gmx.net> 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 по дате отправления: