Re: AW: update on TOAST status'

[ 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026