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'
Re: AW: update on TOAST status' |
Список | 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 по дате отправления: