TOAST

Started by David E. Wheelerabout 25 years ago3 messagesgeneral
Jump to latest
#1David E. Wheeler
david@kineticode.com

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

#2Poul L. Christiansen
poulc@cs.auc.dk
In reply to: David E. Wheeler (#1)
Re: TOAST

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:

Show quoted text

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

#3David Wheeler
david@creationengines.com
In reply to: Poul L. Christiansen (#2)
Re: TOAST

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