Re: Set access strategy for parallel vacuum workers
От
Amit Kapila
Тема
Re: Set access strategy for parallel vacuum workers
Дата
Msg-id
CAA4eK1JBQHRRXXOBoU1x7m2ApYoCUczDvbqwb2TW9hmJ4-srDg@mail.gmail.com
Ответ на
Re: Set access strategy for parallel vacuum workers (Masahiko Sawada)
Список
Дерево обсуждения
Set access strategy for parallel vacuum workers Amit Kapila <amit.kapila16@gmail.com>
Re: Set access strategy for parallel vacuum workers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Set access strategy for parallel vacuum workers Amit Kapila <amit.kapila16@gmail.com>
Re: Set access strategy for parallel vacuum workers Masahiko Sawada <sawada.mshk@gmail.com>
Re: Set access strategy for parallel vacuum workers Amit Kapila <amit.kapila16@gmail.com>
Re: Set access strategy for parallel vacuum workers Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Set access strategy for parallel vacuum workers Amit Kapila <amit.kapila16@gmail.com>
Re: Set access strategy for parallel vacuum workers Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Set access strategy for parallel vacuum workers Amit Kapila <amit.kapila16@gmail.com>
Re: Set access strategy for parallel vacuum workers Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Set access strategy for parallel vacuum workers Amit Kapila <amit.kapila16@gmail.com>
On Wed, Apr 7, 2021 at 5:11 PM Masahiko Sawada wrote: > > On Wed, Apr 7, 2021 at 7:00 PM Amit Kapila wrote: > > > > During recent developments in the vacuum, it has been noticed [1] that > > parallel vacuum workers don't use any buffer access strategy. I think > > we can fix it either by propagating the required information from the > > leader or just get the access strategy in each worker separately. The > > patches for both approaches for PG-13 are attached. > > Thank you for starting the new thread. > > I'd prefer to just have parallel vacuum workers get BAS_VACUUM buffer > access strategy. If we want to have set different buffer access > strategies or ring buffer sizes for the leader and worker processes, > the former approach would be better. But I think we're unlikely to > want to do that, especially in back branches. > Fair enough. Just to be clear, you prefer to go with fix_access_strategy_workers_11.patch, right? -- With Regards, Amit Kapila.
В списке pgsql-hackers по дате отправления