Re: index only scan question - Mailing list pgsql-general

From Daniel Westermann
Subject Re: index only scan question
Date
Msg-id AM4PR0901MB134677E9C9F2664B890F4763D2C60@AM4PR0901MB1346.eurprd09.prod.outlook.com
Whole thread Raw
In response to Re: index only scan question  (Daniel Westermann <daniel.westermann@dbi-services.com>)
Responses Re: index only scan question
List 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 by date:

Previous
From: Daniel Westermann
Date:
Subject: Re: index only scan question
Next
From: Laurenz Albe
Date:
Subject: Re: index only scan question