Re: Smaller data types use same disk space - Mailing list pgsql-general

From Jasen Betts
Subject Re: Smaller data types use same disk space
Date
Msg-id jvinrt$rfh$2@reversiblemaps.ath.cx
Whole thread Raw
In response to Smaller data types use same disk space  ("McGehee, Robert" <Robert.McGehee@geodecapital.com>)
List 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 by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Range-Types in 9.2
Next
From: Craig Ringer
Date:
Subject: Re: Installer problem report with interesting solution