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.