Horton
Menu

Re: POC: Parallel processing of indexes in autovacuum

Masahiko Sawada <sawada.mshk@gmail.com>

View thread
From: Masahiko Sawada <sawada.mshk@gmail.com>
To: Daniil Davydov <3danissimo@gmail.com>
Cc: SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, Sami Imseih <samimseih@gmail.com>, Alexander Korotkov <aekorotkov@gmail.com>, Matheus Alcantara <matheusssilv97@gmail.com>, Maxim Orlov <orlovmg@gmail.com>, Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-03-31T07:09:19Z
Lists: pgsql-hackers

Attachments

On Mon, Mar 30, 2026 at 3:40 AM Daniil Davydov <3danissimo@gmail.com> wrote:
>
> Hi,
>
> On Mon, Mar 30, 2026 at 3:44 PM Daniil Davydov <3danissimo@gmail.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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Allow autovacuum to use parallel vacuum workers.

  2. Add parallel vacuum worker usage to VACUUM (VERBOSE) and autovacuum logs.

  3. doc: Put new options in consistent order on man pages