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