AW: update on TOAST status'

Zeugswetter Andreas SB <zeugswettera@wien.spardat.at>

From: Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
To: "'Jan Wieck'" <JanWieck@Yahoo.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL HACKERS <pgsql-hackers@postgresql.org>
Date: 2000-07-11T14:17:02Z
Lists: 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