AW: update on TOAST status'

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: update on TOAST status'
Дата
Msg-id 11C1E6749A55D411A9670001FA687963367FF3@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Ответы 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))
Список 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 по дате отправления:

Предыдущее
От: Michael J Schout
Дата:
Сообщение: Re: Re: postgres TODO
Следующее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: update on TOAST status'