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.