Re: index prefetching
От
Konstantin Knizhnik
Тема
Re: index prefetching
Дата
Msg-id
316ca3df-d1b0-49ce-ba05-56b342b4cefa@garret.ru
Ответ на
Re: index prefetching (Tomas Vondra)
Список
Дерево обсуждения
index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Andres Freund <andres@anarazel.de>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Andres Freund <andres@anarazel.de>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Andres Freund <andres@anarazel.de>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Robert Haas <robertmhaas@gmail.com>
Re: index prefetching Andres Freund <andres@anarazel.de>
Re: index prefetching Robert Haas <robertmhaas@gmail.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Robert Haas <robertmhaas@gmail.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Robert Haas <robertmhaas@gmail.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Andres Freund <andres@anarazel.de>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Andres Freund <andres@anarazel.de>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Robert Haas <robertmhaas@gmail.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Jim Nasby <jim.nasby@gmail.com>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Robert Haas <robertmhaas@gmail.com>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Konstantin Knizhnik <knizhnik@garret.ru>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Dilip Kumar <dilipbalaut@gmail.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Jakub Wartak <jakub.wartak@enterprisedb.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Jakub Wartak <jakub.wartak@enterprisedb.com>
Re: index prefetching Robert Haas <robertmhaas@gmail.com>
Re: index prefetching Melanie Plageman <melanieplageman@gmail.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Melanie Plageman <melanieplageman@gmail.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Melanie Plageman <melanieplageman@gmail.com>
Re: index prefetching Melanie Plageman <melanieplageman@gmail.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Melanie Plageman <melanieplageman@gmail.com>
Re: index prefetching Melanie Plageman <melanieplageman@gmail.com>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Andres Freund <andres@anarazel.de>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Melanie Plageman <melanieplageman@gmail.com>
Re: index prefetching Andres Freund <andres@anarazel.de>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Andres Freund <andres@anarazel.de>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Robert Haas <robertmhaas@gmail.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Robert Haas <robertmhaas@gmail.com>
Re: index prefetching Andres Freund <andres@anarazel.de>
Re: index prefetching Robert Haas <robertmhaas@gmail.com>
Re: index prefetching Peter Smith <smithpb2250@gmail.com>
Re: index prefetching Dilip Kumar <dilipbalaut@gmail.com>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Dilip Kumar <dilipbalaut@gmail.com>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Peter Geoghegan <pg@bowt.ie>
Re: index prefetching Gregory Smith <gregsmithpgsql@gmail.com>
Re: index prefetching Tomasz Rybak <tomasz.rybak@post.pl>
On 22/01/2024 1:47 am, Tomas Vondra wrote:
h, right. Well, you're right in this case we perhaps could set just oneof those flags, but the "purpose" of the two places is quite different. The "prefetch" flag is fully controlled by the prefetcher, and it's up to it to change it (e.g. I can easily imagine some new logic touching setting it to "false" for some reason). The "data" flag is fully controlled by the custom callbacks, so whatever the callback stores, will be there. I don't think it's worth simplifying this. In particular, I don't think the callback can assume it can rely on the "prefetch" flag.
Why not to add "all_visible" flag to IndexPrefetchEntry ? If will not cause any extra space overhead (because of alignment), but allows to avoid dynamic memory allocation (not sure if it is critical, but nice to avoid if possible).
В списке pgsql-hackers по дате отправления