| From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
|---|---|
| To: | Ioannis Theoharis <theohari(at)ics(dot)forth(dot)gr>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Raw size |
| Date: | 2005-03-10 21:28:06 |
| Message-ID: | c2d9e70e05031013284ea7334f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 10 Mar 2005 20:07:13 +0200 (EET), Ioannis Theoharis
<theohari(at)ics(dot)forth(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2005-03-10 21:37:13 | Re: [HACKERS] We are not following the spec for HAVING without GROUP |
| Previous Message | Bruce Momjian | 2005-03-10 21:26:47 | Re: [pgsql-hackers-win32] snprintf causes regression tests |