varchar(), text,char() overhead - Mailing list pgsql-hackers

From Bruce Momjian
Subject varchar(), text,char() overhead
Date
Msg-id 199801212129.QAA25848@candle.pha.pa.us
Whole thread Raw
List pgsql-hackers
Do people want the overhead of char(), varchar(), and text to be reduced
from 4-bytes to 2-bytes.  We store the length in this overhead, but
since we have a size limit on tuple size, we can't have a field over 8k
in size anyway.  Even if we up that to 32k for 6.3, we still only use 2
bytes.

I have added it to the TODO list.  Most of the code already supports it
by using VARSIZE and VARDATA macros.  Once the structure size changes,
the macros change too.  The only issue is places where they take the
first four bytes of the variable-length type and cast it to an int32,
which will not work in this case.  We have to change this so it uses the
macros too.

--
Bruce Momjian
maillist@candle.pha.pa.us

pgsql-hackers by date:

Previous
From: ocie@paracel.com
Date:
Subject: Re: [HACKERS] Re: [QUESTIONS] Business cases
Next
From: darrenk@insightdist.com (Darren King)
Date:
Subject: Re: [HACKERS] varchar(), text,char() overhead