TOAST suggestion...

Chris Bitmead <chris@bitmead.com>

From: Chris Bitmead <chris@bitmead.com>
To: pgsql-hackers@postgresql.org
Date: 2000-01-24T07:26:17Z
Lists: pgsql-hackers
Can I make a suggestion for toast? I don't know how much this is thought
about yet, but it seems like it would be a good idea if large object
support be re-implemented in terms of TOAST (when it is available).
Because current
large objects suck so much.

Can I suggest that the TOAST system should be implemented to allow for
random access?
So for example, to retrieve a whole data member, of course it looks
normal...

SELECT xxx from yyy;

But to retrieve a particular chunk....

SELECT PORTION(xxx, 65535, 131071) from yyy; 

to retrieve the 2nd 64k chunk.

This could be useful for many sorts of apps.