AW: update on TOAST status' - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: update on TOAST status'
Date
Msg-id 11C1E6749A55D411A9670001FA687963367FF3@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: update on TOAST status'  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: AW: update on TOAST status'  (JanWieck@t-online.de (Jan Wieck))
List pgsql-hackers
>     It appears that brtee indices (at least) can keep  references
>     to  old  toast  values  that  survive  a  VACUUM! Seems these
>     references live in nodes actually not  referring  to  a  heap
>     tuple   any   more,   but   used  during  tree  traversal  in
>     comparisions.  As if an index tuple delete from a  btree  not
>     necessarily  causes  the  index  value  to disappear from the
>     btree completely.  It'll never be returned by an index  scan,
>     but the value is still there somewhere.

Would it be possible to actually delete those entries during vacuum ?
I guess that would be an overall win, no ?

Andreas


pgsql-hackers by date:

Previous
From: Michael J Schout
Date:
Subject: Re: Re: postgres TODO
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: update on TOAST status'