About TOAST and indices - Mailing list pgsql-hackers

From JanWieck@t-online.de (Jan Wieck)
Subject About TOAST and indices
Date
Msg-id 200007201520.RAA05115@hot.jw.home
Whole thread Raw
Responses Re: About TOAST and indices  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,
   up to now, TOAST would be a v7.1 show-stopper, because due to   the upper-block btree references  problem,  it's
not VACUUM   safe  if there's a btree index on a toastable attribute (like   text).
 
   The only clean way to get rid of these upper-block references   is to recreate the indices from scratch, instead of
vacuuming  them in the crash-safe manner we do now. But doing  so  needs   file  versioning,  and I don't expect it to
beimplemented in   v7.1.
 
   So at the time  beeing,  I  think  index  tuples  should  not   contain  any external toast references. I'll change
theheap-   am/toaster combo temporarily to do that.  All  that  will  be   covered  by  #ifdef, so we can switch back
easilyat the time   we have file versioning to unlimit indexed attribute sizes as   well.
 
   Comments?


Jan

--

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




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8Ko limitation
Next
From: Adriaan Joubert
Date:
Subject: Re: Loading binary data into the database