Re: Smaller data types use same disk space

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: Smaller data types use same disk space
Дата
Msg-id jvinrt$rfh$2@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на Smaller data types use same disk space  ("McGehee, Robert" <Robert.McGehee@geodecapital.com>)
Список pgsql-general
On 2012-07-25, Steve Crawford <scrawford@pinpointresearch.com> wrote:

>
> How are your determining the space used by a table?
>
> Why are you assuming 7 bytes for a 3-character value? (Character values
> up to 126 characters long only have 1-character overhead.)

character values upto 127 octets long only have one octet overhead.

three characters could take as many as 18 octets before overhead.
(not that I've ever encountered a unicode code point past 2^24 -)

--
⚂⚃ 100% natural

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