Re: index only scan question

From: Daniel Westermann <daniel(dot)westermann(at)dbi-services(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: index only scan question
Date: 2018-11-09 14:57:34
Message-ID: AM4PR0901MB13460A857081987E4733CCBED2C60@AM4PR0901MB1346.eurprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Westermann 2018-11-09 14:59:29 Re: index only scan question
Previous Message Daniel Westermann 2018-11-09 14:00:38 Re: index only scan question