text should be a blob field - Mailing list pgsql-hackers

From Zeugswetter Andreas SARZ
Subject text should be a blob field
Date
Msg-id 219F68D65015D011A8E000006F8590C6010A51F7@sdexcsrv1.sd.spardat.at
Whole thread Raw
Responses Re: [HACKERS] text should be a blob field
List pgsql-hackers
Of course a first mail after a release must have the earned praise:
Very nicely done, I like it all ;-)

Reading the TODO, I see 'Allow text, char(), and varchar() overhead to be
only 2 bytes, not 4 bytes'
While this is very good for char and varchar, text is not a candidate
since it is usually a blob datatype, without a length restriction (or a 2Gig
limit).

I think it should alternately read:
Allow varchar() overhead to be only 2 bytes
remove char() 4 byte overhead, use atttypmod instead
make text a blob datatype (maybe storing <= 8k row with tuple, >=8k in blob
tablespace)

What do you think ?
Andreas

pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [HACKERS] patches now that 6.3 has been released
Next
From: "Thomas G. Lockhart"
Date:
Subject: Lost a function overloading capability in v6.3