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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-03-03 13:54:34 | Lost a function overloading capability in v6.3 |
Previous Message | The Hermit Hacker | 1998-03-03 13:31:51 | Re: [HACKERS] PostgreSQL - the Linux of Databases... |