Thread: TOAST

Greetings All,

I've seem some references to TOAST in 7.1. Can anyone tell me what it is
and/or where I can read all about it and how it will solve all my problems
using BLOBs with PostgreSQL?

Thanks!

David

Hi

http://www.postgresql.org/projects/devel-toast.html

The TOAST project transparently allows you to store text (I don't know about
BLOB's) with size >8KB. AFAIK there is no length limit with TOAST.

HTH,
Poul L. Christiansen

David Wheeler wrote:

> Greetings All,
>
> I've seem some references to TOAST in 7.1. Can anyone tell me what it is
> and/or where I can read all about it and how it will solve all my problems
> using BLOBs with PostgreSQL?
>
> Thanks!
>
> David

On Fri, 9 Feb 2001, Poul L. Christiansen wrote:

> Hi
>
> http://www.postgresql.org/projects/devel-toast.html
>
> The TOAST project transparently allows you to store text (I don't know about
> BLOB's) with size >8KB. AFAIK there is no length limit with TOAST.

Thanks, Paul. I appreciate the response and the pointer to the web page. I
sure wish the search engine on postgresql.org worked better so that I may
have found that page myself!

David