[ Charset ISO-8859-1 unsupported, converting... ]
>
> > 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 ?
Seems that is the only good solution, or somehow link vacuum of TOAST
tables to index so these TOAST values are not removed.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
