Re: TOAST and TEXT

Rod Taylor wrote:
> It should be noted that there is still a limit of about 1GB if I
> remember correctly.
   You're right, there is still a practical limit on the size of   a text field. And it's usually much lower than 1GB.
   The problem is that first, the (encoded) data has to  be  put   completely  into  the  querystring, passed to the
backendand   buffered there entirely in memory. Then it get's parsed,  and   the  data  copied  into  a  const  node.
Afterrewriting and   planning, a  heap  tuple  is  build,  containing  the  third,   eventually fourth in memory copy
ofthe data. After that, the   toaster kicks in, allocates another chunk of that size to try   to compress the data and
finallyslices it up for storage.
 
   So the limit depends on how much swapspace you have and where   the per process virtual memory limit of your OS is.
   In practice, sizes of up to 10 MB are no problem. So  storing   typical MP3s works.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com