Re: Smaller data types use same disk space

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Smaller data types use same disk space
Date: 2012-08-04 08:52:13
Message-ID: jvinrt$rfh$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2012-07-25, Steve Crawford <scrawford(at)pinpointresearch(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-08-04 09:05:11 Re: Installer problem report with interesting solution
Previous Message Andreas Kretschmer 2012-08-04 07:14:26 Re: Range-Types in 9.2