Re: Raw size - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Raw size
Date
Msg-id c2d9e70e05031013284ea7334f@mail.gmail.com
Whole thread Raw
In response to Raw size  (Ioannis Theoharis <theohari@ics.forth.gr>)
List pgsql-hackers
On Thu, 10 Mar 2005 20:07:13 +0200 (EET), Ioannis Theoharis
<theohari@ics.forth.gr> wrote:
> 
> 
> Hi,
> 
> i have a table:
> 
> create table triples(
>     att0 varchar(1000),
>     att1 int4,
>     att2 varchar(20),
>     att3 varchar(1000)
> )
> 
> My table has 990 raws.
> 
> The (possibly wrong) way, with wich i compute the size of the table is:
> att0: 1000 * 1 Byte + 4 = 1004 Bytes
>
i don't know what the varchar size is in byte but i think is not 1 per
character. IIRC, it varies on diferent encodings.

regards,
Jaime Casanova


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [pgsql-hackers-win32] snprintf causes regression tests
Next
From: Mark Kirkwood
Date:
Subject: Re: We are not following the spec for HAVING without GROUP