On 2012-07-25, Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general