Re: Index only scan and ctid - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Index only scan and ctid
Date
Msg-id 24815.1580759003@sss.pgh.pa.us
Whole thread Raw
In response to Index only scan and ctid  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Index only scan and ctid
List pgsql-hackers
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> I noticed that "ctid" in the select list prevents an index only scan:
> This strikes me as strange, since every index contains "ctid".

There's no provision for an IOS to return a system column, though.
Not sure what it'd take to make that possible.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Index only scan and ctid
Next
From: Pavel Stehule
Date:
Subject: Re: [Proposal] Global temporary tables