Re: index-only-scan when there is an index on all columns - Mailing list pgsql-general

From David G. Johnston
Subject Re: index-only-scan when there is an index on all columns
Date
Msg-id CAKFQuwbs8rfMk4TodXU_YzaW7BR1krY+ttATqJge2nS-jtTUEg@mail.gmail.com
Whole thread Raw
In response to Re: index-only-scan when there is an index on all columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Feb 27, 2018 at 2:58 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"David G. Johnston" <david.g.johnston@gmail.com> writes:
 
> Also, I recall discussion that select statements will touch the visibility
> map (hence causing write I/O even in a read-only query) but [1] indicates
> that only vacuum will set them ddl will clear them.

Hm, I don't recall that, but I've not been involved in the last few rounds
of hacking on that mechanism.

​I was confusing hint bits with the visibility map, sorry for the noise and/or confusion.

David J.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: index-only-scan when there is an index on all columns
Next
From: Andres Freund
Date:
Subject: Re: index-only-scan when there is an index on all columns