| From: | "frank joerdens" <frank(at)joerdens(dot)de> |
|---|---|
| To: | <Pgsql-General(at)Postgresql(dot)org> |
| Subject: | How does TOAST compare to other databases' mechanisms? |
| Date: | 2000-10-02 17:41:47 |
| Message-ID: | 005701c02c98$0a3599f0$0164a8c0@joerdens.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
If this question is answered in some FAQ, I'd be happy just for some
pointer. If not, what I'd like to know is this: Since I will be using
PostgreSQL (because it's the database I know best and because I like it ;))
for a content management type app where I need TOAST, I am wondering whether
this mechanism is actually something really advanced and neat (this is what
I'd assume) or if it is a not-so-elegant, rather involved construction to
get around a legacy limitation? To put it another way: Can I go around
bragging to my SQL-minded friends about using this really cool thing that no
other database has, or should I keep my mouth shut because it's actually not
so cool? How do the MySQL people do it (there's a pretty instructive
comparison of MySQL and PostgreSQL at
http://www.phpbuilder.com/columns/tim20000705.php3 in the context of both
databases' suitability as a web site backend which mentions the 8k barrier
as one of the bigger minuses of PostgreSQL - it's a head-to-head race in
this comparison by the way, which makes it particularly interesting)? What's
Oracle's answer to oversized attributes (or other advanced DBMS's, like
Sybase, Informix et al)?
Thanks, Frank
--
frank joerdens
joerdens new media e: frank(at)joerdens(dot)de
urbanstr. 116 m: +49 (0)30 69597650
10967 berlin f: +49 (0)30 7864046
germany h: http://www.joerdens.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Franz J Fortuny | 2000-10-02 18:09:12 | Advise requested and suggestions welcome |
| Previous Message | Michael Ansley | 2000-10-02 16:40:11 | OIDs |