Re: index only scan question

Поиск
Список
Период
Сортировка
От Daniel Westermann
Тема Re: index only scan question
Дата
Msg-id AM4PR0901MB134677E9C9F2664B890F4763D2C60@AM4PR0901MB1346.eurprd09.prod.outlook.com
обсуждение исходный текст
Ответ на Re: index only scan question  (Daniel Westermann <daniel.westermann@dbi-services.com>)
Ответы Re: index only scan question  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general

sorry, hit the wrong key


>I'd say the old index tuple was killed during the first scan:
>https://www.cybertec-postgresql.com/en/killed-index-tuples/

... from your blog: "Whenever an index scan fetches a heap tuple only to find that it is dead (that the entire “HOT chain” of tuples is dead, to be more precise), it marks the index tuple as “killed”. Then future index scans can simply ignore it.

I understand that, but in my case the chain is not dead so this does not explain the difference. Do I miss something?

Regards
Daniel

В списке pgsql-general по дате отправления:

Предыдущее
От: Daniel Westermann
Дата:
Сообщение: Re: index only scan question
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: index only scan question