Re: Raw size

From: "Bort, Paul" <pbort(at)tmwsystems(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Raw size
Date: 2005-03-10 18:15:47
Message-ID: 735D404BD9E7EB44B9CDFC27FC88809B0582DAB6@mail2.tmwsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> 990 * 2072 = 2,051,280 Bytes
>
> BUT after clustering triples according to an index on att1:
>
<snip>
>
> 142 * 8 * 1024 = 1,163,264 Bytes
>
>
> Is there any compression or what?
>

varchar means 'character varying'. What varies is the length. So a
varchar(1000) with 'foo' in it only takes a few bytes ('foo' plus length
info) instead of 1000 bytes.

If you really want a fixed-length field, nchar or char should do what you
want.

Responses

  • Re: Raw size at 2005-03-11 13:08:34 from Ioannis Theoharis

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin HaleBoyes 2005-03-10 18:21:14 Re: [HACKERS] We are not following the spec for HAVING without GROUP
Previous Message Gill, Jerry T. 2005-03-10 18:13:31 Re: [HACKERS] We are not following the spec for HAVING without GROUP BY