Re: index-only-scan when there is an index on all columns
От
David G. Johnston
Тема
Re: index-only-scan when there is an index on all columns
Дата
Msg-id
CAKFQuwbs8rfMk4TodXU_YzaW7BR1krY+ttATqJge2nS-jtTUEg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
index-only-scan when there is an index on all columns Hadi Moshayedi <hadi@citusdata.com>
Re: index-only-scan when there is an index on all columns Tom Lane <tgl@sss.pgh.pa.us>
Re: index-only-scan when there is an index on all columns "David G. Johnston" <david.g.johnston@gmail.com>
Re: index-only-scan when there is an index on all columns Tom Lane <tgl@sss.pgh.pa.us>
Re: index-only-scan when there is an index on all columns Andres Freund <andres@anarazel.de>
Re: index-only-scan when there is an index on all columns David Rowley <david.rowley@2ndquadrant.com>
Re: index-only-scan when there is an index on all columns Andres Freund <andres@anarazel.de>
Re: index-only-scan when there is an index on all columns "David G. Johnston" <david.g.johnston@gmail.com>
"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 по дате отправления
От: Andres Freund
Дата: