Skip site navigation (1) Skip section navigation (2)

text should be a blob field

From: Zeugswetter Andreas SARZ <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org>
Subject: text should be a blob field
Date: 1998-03-03 13:41:32
Message-ID: 219F68D65015D011A8E000006F8590C6010A51F7@sdexcsrv1.sd.spardat.at (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-hackers by date

Next:From: Thomas G. LockhartDate: 1998-03-03 13:54:34
Subject: Lost a function overloading capability in v6.3
Previous:From: The Hermit HackerDate: 1998-03-03 13:31:51
Subject: Re: [HACKERS] PostgreSQL - the Linux of Databases...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group