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