Re: Patch for 'Not to stuff everything as files in a single directory, hash dirs''

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 #