Re: lots of large objects and toast - Mailing list pgsql-general

From Tom Lane
Subject Re: lots of large objects and toast
Date
Msg-id 17751.959656927@sss.pgh.pa.us
Whole thread Raw
In response to Re: lots of large objects and toast  (Lincoln Yeoh <lylyeoh@mecomb.com>)
Responses Re: lots of large objects and toast
Re: lots of large objects and toast
List pgsql-general
Lincoln Yeoh <lylyeoh@mecomb.com> writes:
>> There's never been much enthusiasm among the core developers for large
>> objects at all --- we see them as a poor substitute for allowing large
>> values directly.  (The "TOAST" work scheduled for 7.1 will finally
>> resolve that issue, I hope.)  So no one's felt like working on improving
>> the large-object implementation.

> On the practical side, say I want to insert/read a large amount of
> information into/from a TOAST field. How should I do it?
> Is there a pipe method where I can continuously print to/read from?

Not at the moment, but that's obviously going to be a necessary feature
if we want to make the existing flavor of large objects obsolete.  There
have been some preliminary discussions about it --- AFAIR no one's laid
out a complete proposal yet.

            regards, tom lane

pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: Postgresql usage clip.
Next
From: Ron Chmara
Date:
Subject: Re: Postgresql usage clip.