Re: POC: Parallel processing of indexes in autovacuum

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Daniil Davydov <3danissimo(at)gmail(dot)com>
Cc: SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Sami Imseih <samimseih(at)gmail(dot)com>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Matheus Alcantara <matheusssilv97(at)gmail(dot)com>, Maxim Orlov <orlovmg(at)gmail(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: POC: Parallel processing of indexes in autovacuum
Date: 2026-03-31 07:09:19
Message-ID: CAD21AoAqkBtCYwuwbiJ6qA+Ny-pO4idpfgqZBDxE6tGgHTpm1A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Mar 30, 2026 at 3:40 AM Daniil Davydov <3danissimo(at)gmail(dot)com> wrote:
>
> Hi,
>
> On Mon, Mar 30, 2026 at 3:44 PM Daniil Davydov <3danissimo(at)gmail(dot)com> wrote:
> >
> > BTW, describing the cost limit propagation to the parallel a/v workers is
> > worth mentioning in the documentation. I'll add it in the next patch version.
> >
>
> You can find these changes in the v33 patch.
>
> I mentioned cost delay parameters propagation only in "The Autovacuum Daemon"
> chapter. I am not sure that we also should write about parallel workers in the
> "Vacuuming" chapter (within cost based parameters description) since VACUUM
> PARALLEL doesn't do so.
>
> The only change in the 0001 patch is removing redundant empty line
> inside autovacuum.c .

Thank you for updating the patch!

I've made some changes to the documentation part, merged two patches
into one, and updated the commit message. Please review the attached
patch.

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com

Attachment Content-Type Size
v34-0001-Allow-autovacuum-to-use-parallel-vacuum-workers.patch text/x-patch 42.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2026-03-31 07:10:51 Re: Adding locks statistics
Previous Message Alexander Lakhin 2026-03-31 07:00:00 Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE