Re: Set access strategy for parallel vacuum workers

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: Set access strategy for parallel vacuum workers
Дата
Msg-id CAD21AoASRqUhgD4_YiRuOwm8B+3tW3Y+CnEdzKybNW688TOObA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Set access strategy for parallel vacuum workers  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: Set access strategy for parallel vacuum workers
Список pgsql-hackers
On Thu, Apr 8, 2021 at 12:17 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Wed, Apr 7, 2021 at 5:11 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
> >
> > On Wed, Apr 7, 2021 at 7:00 PM Amit Kapila <amit.kapila16@gmail.com> 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?

That's right.

In HEAD, we fixed it in that way in commit f6b8f19.

Regards,

-- 
Masahiko Sawada
EDB:  https://www.enterprisedb.com/



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Set access strategy for parallel vacuum workers
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Autovacuum on partitioned table (autoanalyze)