Re: Raw size

Jaime Casanova <systemguards@gmail.com>

From: Jaime Casanova <systemguards@gmail.com>
To: Ioannis Theoharis <theohari@ics.forth.gr>, pgsql-hackers@postgresql.org
Date: 2005-03-10T21:28:06Z
Lists: 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