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>
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 по дате отправления
От: Tom Lane
Дата:
От: Andres Freund
Дата:
FAQ