MIME-Version: 1.0
References: 
 <CACG=ezZOrNsuLoETLD1gAswZMuH2nGGq7Ogcc0QOE5hhWaw=cw@mail.gmail.com>
 <CAD21AoCdx5ZNS_cO7bYz1Zfb+Kw1kuJV2wtewrz7T1pPpjcWGw@mail.gmail.com>
 <CAA5RZ0vN_RjrHR+HXTkfHydRDZ-yGrpapWQ3-oGj1W34AoftmQ@mail.gmail.com>
In-Reply-To: 
 <CAA5RZ0vN_RjrHR+HXTkfHydRDZ-yGrpapWQ3-oGj1W34AoftmQ@mail.gmail.com>
From: Masahiko Sawada <sawada.mshk@gmail.com>
Date: Fri, 2 May 2025 15:06:41 -0700
Message-ID: 
 <CAD21AoCa9g7db+0mBayM-EcEO+wQjWV9bwvV3qPg_3ZCyqsMNg@mail.gmail.com>
Subject: Re: POC: Parallel processing of indexes in autovacuum
To: Sami Imseih <samimseih@gmail.com>
Cc: Maxim Orlov <orlovmg@gmail.com>,
	Postgres hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAD21AoCa9g7db%2B0mBayM-EcEO%2BwQjWV9bwvV3qPg_3ZCyqsMNg%40mail.gmail.com>
Precedence: bulk

On Fri, May 2, 2025 at 9:58=E2=80=AFAM Sami Imseih <samimseih@gmail.com> wr=
ote:
>
> > Once we have parallel heap vacuum, as discussed in thread[1], it would
> > also likely be beneficial to incorporate it into autovacuum during
> > aggressive vacuum or failsafe mode.
>
> IIRC, index cleanup is disabled by failsafe.

Yes. My idea is to use parallel *heap* vacuum in autovacuum during
failsafe mode. I think it would make sense as users want to complete
freezing tables as soon as possible in this situation.

Regards,

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