AW: Adding index flag showing tuple status
От | Zeugswetter Andreas SB |
---|---|
Тема | AW: Adding index flag showing tuple status |
Дата | |
Msg-id | 11C1E6749A55D411A9670001FA6879633682D0@sdexcsrv1.f000.d0188.sd.spardat.at обсуждение исходный текст |
Ответы |
Re: AW: Adding index flag showing tuple status
Re: AW: Adding index flag showing tuple status |
Список | pgsql-hackers |
> I am looking at adding an index tuple flag to indicate when a > heap tuple is expired so the index code can skip looking up the heap tuple. > > The problem is that I can't figure out how be sure that the heap tuple > doesn't need to be looked at by _any_ backend. Right now, we update the > transaction commit flags in the heap tuple to prevent a pg_log lookup, > but that is not enough because some transactions may still see that heap > tuple as visible. If you are only marking those, that need not be visible anymore, can you not simply delete that key (slot) from the index ? I know vacuum then shows a count mismatch, but that could probably be accounted for. Andreas
В списке pgsql-hackers по дате отправления: