Horton
Menu

Re: POC: Parallel processing of indexes in autovacuum

Daniil Davydov <3danissimo@gmail.com>

View thread
From: Daniil Davydov <3danissimo@gmail.com>
To: SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
Cc: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, Masahiko Sawada <sawada.mshk@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-30T10:40:05Z
Lists: pgsql-hackers

Attachments

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 .

--
Best regards,
Daniil Davydov

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