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

My idea was to implement the large object API on top of TOAST.

> 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(at)Yahoo(dot)com #
>
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026