Thread: Large Text Fields and TOAST

Large Text Fields and TOAST

From
"Lee Russell"
Date:
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.

Thanks, Lee




Re: Large Text Fields and TOAST

From
Stephan Szabo
Date:
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.