Re: Large Text Fields and TOAST

Well, TOAST should be fairly transparent to users I believe. TOAST
values should be compressed or stored separately from the rest of
the row's data to get around the 8-32k block size.

There's also the large object support which is something else entirely.

On Fri, 9 Mar 2001, Lee Russell wrote:

> hi,
>
> I an using postgresql-7.1beta4 and am trying to use the large text fields.
>
> I have heard of TOAST. There is little documentation.
>
> I found one section about creating a data type,
>
> then creating two functions to convert the data types.
>
> Is this how TOAST is implemented?
>
> Am I on the right track?. If so, what do
>
> the conversion functions look like. I am using plpgsql.