Bruce Momjian wrote:
> Seems the whole large object per file is going away in 7.1. Can someone
> confirm this?
Not the whole one in 7.1.
The TOAST stuff will lower the need for large objects alot, but we already discovered the fact that it isn't
a real answer to LARGE objects.
First of all, the entire datum must be properly quoted to fit into a querystring. Therefore the client needs to
have the original datum, the qouted copy, the querystring it built. Then the querystring is sent to the backend,
parsed(where a CONST node is built from it), copied into a tuple to be split up into TOAST items.
So on a central system, where client and DB are both running, we have 6 copies of the object in memory! Not that
optimal.
For 7.2 I'll work on real CLOB and BLOB data types. Requires some more thinking though.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #