Thread

1. TOAST

   Pam Withnall <pamw@zoom.com.au> — 2001-03-09T02:54:40Z

   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, Pam
   
   
   

2. Re: TOAST

   Frank Joerdens <frank@joerdens.de> — 2001-03-13T08:11:15Z

   On Fri, Mar 09, 2001 at 01:54:40PM +1100, Pam Withnall 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.
   > Thanks, Pam
   
   TOAST works transparently for the user. It just means that the old
   pre-7.1 8k (actually 32) row length limit is obsolete. In order to use
   large text fields all you need to do is install 7.1 (which you already
   have, as you say). No function creation etc. is required.
   
   Regards, Frank