Re: Improve eviction algorithm in ReorderBuffer
От
Heikki Linnakangas
Тема
Re: Improve eviction algorithm in ReorderBuffer
Дата
Msg-id
7c30177d-068a-47ff-ac4b-0e493decc143@iki.fi
Ответ на
Re: Improve eviction algorithm in ReorderBuffer (Amit Kapila)
Список
Дерево обсуждения
Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer "Euler Taveira" <euler@eulerto.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Dilip Kumar <dilipbalaut@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Amit Kapila <amit.kapila16@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Amit Kapila <amit.kapila16@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Amit Kapila <amit.kapila16@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Amit Kapila <amit.kapila16@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer vignesh C <vignesh21@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
RE: Improve eviction algorithm in ReorderBuffer "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
RE: Improve eviction algorithm in ReorderBuffer "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Improve eviction algorithm in ReorderBuffer Shubham Khanna <khannashubham1197@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Ajin Cherian <itsajin@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Ajin Cherian <itsajin@gmail.com>
RE: Improve eviction algorithm in ReorderBuffer "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer vignesh C <vignesh21@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Amit Kapila <amit.kapila16@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer vignesh C <vignesh21@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Peter Smith <smithpb2250@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer vignesh C <vignesh21@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Amit Kapila <amit.kapila16@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Heikki Linnakangas <hlinnaka@iki.fi>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Michael Paquier <michael@paquier.xyz>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Michael Paquier <michael@paquier.xyz>
Re: Improve eviction algorithm in ReorderBuffer Heikki Linnakangas <hlinnaka@iki.fi>
Re: Improve eviction algorithm in ReorderBuffer Jeff Davis <pgsql@j-davis.com>
Re: Improve eviction algorithm in ReorderBuffer Amit Kapila <amit.kapila16@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Heikki Linnakangas <hlinnaka@iki.fi>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Heikki Linnakangas <hlinnaka@iki.fi>
RE: Improve eviction algorithm in ReorderBuffer "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Michael Paquier <michael@paquier.xyz>
Re: Improve eviction algorithm in ReorderBuffer Heikki Linnakangas <hlinnaka@iki.fi>
RE: Improve eviction algorithm in ReorderBuffer "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Shubham Khanna <khannashubham1197@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Peter Smith <smithpb2250@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Peter Smith <smithpb2250@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Peter Smith <smithpb2250@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Peter Smith <smithpb2250@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Peter Smith <smithpb2250@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer vignesh C <vignesh21@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Dilip Kumar <dilipbalaut@gmail.com>
Re: Improve eviction algorithm in ReorderBuffer Peter Smith <smithpb2250@gmail.com>
On 10/04/2024 08:31, Amit Kapila wrote: > On Wed, Apr 10, 2024 at 11:00 AM Heikki Linnakangas wrote: >> >> On 10/04/2024 07:45, Michael Paquier wrote: >>> On Tue, Apr 09, 2024 at 09:16:53PM -0700, Jeff Davis wrote: >>>> On Wed, 2024-04-10 at 12:13 +0900, Michael Paquier wrote: >>>>> Wouldn't the best way forward be to revert >>>>> 5bec1d6bc5e3 and revisit the whole in v18? >>>> >>>> Also consider commits b840508644 and bcb14f4abc. >>> >>> Indeed. These are also linked. >> >> I don't feel the urge to revert this: >> >> - It's not broken as such, we're just discussing better ways to >> implement it. We could also do nothing, and revisit this in v18. The >> only must-fix issue is some compiler warnings IIUC. >> >> - It's a pretty localized change in reorderbuffer.c, so it's not in the >> way of other patches or reverts. Nothing else depends on the binaryheap >> changes yet either. >> >> - It seems straightforward to repeat the performance tests with whatever >> alternative implementations we want to consider. >> >> My #1 choice would be to write a patch to switch the pairing heap, >> performance test that, and revert the binary heap changes. >> > > +1. To move this forward, here's a patch to switch to a pairing heap. In my very quick testing, with the performance test cases posted earlier in this thread [1] [2], I'm seeing no meaningful performance difference between this and what's in master currently. Sawada-san, what do you think of this? To be sure, if you could also repeat the performance tests you performed earlier, that'd be great. If you agree with this direction, and you're happy with this patch, feel free take it from here and commit this, and also revert commits b840508644 and bcb14f4abc. -- Heikki Linnakangas Neon (https://neon.tech)
В списке pgsql-hackers по дате отправления