Re: [GENERAL] space-effective varchar(255)-like arrangement

 Hmm, let me guess ...

  one of the overhead elements for each row header is pointer to the next
row, right ? That way the summing-up of varlena types is avoided, although
the postgres engine still has to go from row header to row header to find
Nth row in a page (block), right ?

   Thx,

        Jan



On Sat, 26 Dec 1998, Jan Vicherek wrote:

> On Sat, 26 Dec 1998, Bruce Momjian wrote:
> >
> > See the FAQ under character types.  varcahr() does not store the max
> > space, only used space.
>
>    hmm, thus if one block has 8192 bytes, and if there is 9-byte overhead
> for each row, then I can store 390 rows in one block if, on average,
> "names" are 10 chars in length ? echo $[ 8192 / ( 9 + 10 + 2 ) ] # = 390
>
>    If each record has variable length, pg has no way of calculating where
> is start of next record, other than going through the block and summing up
> lengths of varchars to determine where does next record begin, right ?
> (above I use word "record" and "row" interchangeably).
>
>     Thanx a bunch,
>
>         Jan
>
>
>
>  -- Gospel of Jesus is the saving power of God for all who believe --
>                 ## To some, nothing is impossible. ##
>                    http://Vicherek.Waterloo.on.ca/
>
>

 -- Gospel of Jesus is the saving power of God for all who believe --
                ## To some, nothing is impossible. ##
                   http://Vicherek.Waterloo.on.ca/