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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres automatically inserts chr(13) whenever chr(10) is inserted
Следующее
От: "Just Someone"
Дата:
Сообщение: Re: SELinux strangeness with 8.1.2 and 8.1.3