Index toasting (was: Re: [HACKERS] Error "vacuum pg_proc") - Mailing list pgsql-hackers

From Jan Wieck
Subject Index toasting (was: Re: [HACKERS] Error "vacuum pg_proc")
Date
Msg-id 3870E982.B123DF8A@debis.com
Whole thread Raw
In response to Re: [HACKERS] Error "vacuum pg_proc"  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Index toasting (was: Re: [HACKERS] Error "vacuum pg_proc")
List pgsql-hackers
Tom Lane wrote:

> I wrote:
> > And that'll still crash and burn for multicolumn indexes.
>
> Not to mention functional indexes, which typically store values that
> don't appear in the referenced tuple at all.
>
> Basically, indexes have to have their own toasters.  There's no other
> way.
    You're right.
    I think it's best to delay index toasting until we have some    experience with normal, main tuple attribute
toasting.It'd be    nice if the solution had covered huge values to be indexed    automatically (what it doesn't any
more).But I think most    people can live with a database, that cannot index huge    values, but is capable to store
andretrieve them for now.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #





pgsql-hackers by date:

Previous
From: Ed Loehr
Date:
Subject: Re: [HACKERS] Docs
Next
From: Stephen Birch
Date:
Subject: Re: [HACKERS] Re: date/time type changes