Re: Question about todo item - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: Question about todo item
Date
Msg-id 200108061435.f76EZ0207022@jupiter.us.greatbridge.com
Whole thread Raw
In response to Re: Question about todo item  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Question about todo item
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I agree we should have it, but I thought the problem was that we
> > couldn't come up with an API that worked.
>
> AFAIR, no one's really tried yet.  I do not recall any proposals
> getting shot down ...
   One  of  the problems I saw, and that's probably why we don't   have a proposal yet,  is,  that  the  size  of  the
data is   recorded  in  the  toast reference held in the main tuple. If   you later open the toast value for writing,
you'llchange the   size,  but  you'd  need  to  change it in the main tuple too,   what'd require a regular update on
the main  tuple,  what  I   don't think we want to have here.
 
   The  other  problem  is,  if  you insert a tuple containing a   small value (e.g.  empty string), it'll not get
toasted and   you  can't force it to get. Later you open it for writing and   pump a CD-image into. How do we convert
the existing  empty   text datum into a toast reference in the main tuple?
 


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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Possible solution for LIKE optimization
Next
From: Jan Wieck
Date:
Subject: Re: Question about todo item