Re: parallel vacuum comments

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: "tanghy(dot)fnst(at)fujitsu(dot)com" <tanghy(dot)fnst(at)fujitsu(dot)com>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie>, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: parallel vacuum comments
Date: 2021-12-21 05:53:37
Message-ID: CAD21AoBSVQfVGLog0z=n==xEGpLP+sAr0jSh2Z4cK0vw-BjC1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Dec 21, 2021 at 2:04 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Tue, Dec 21, 2021 at 10:05 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
> >
> > On Tue, Dec 21, 2021 at 12:05 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> > >
> > > On Mon, Dec 20, 2021 at 6:29 PM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
> >
> > > BTW, if we go with that then we should set the correct phase
> > > for workers as well?
> >
> > If we have separate error context for the leader (vacuumlazy.c) and
> > workers (vacuumparallel.c), workers don't necessarily need to have the
> > phases such as VACUUM_ERRCB_PHASE_VACUUM_INDEX and
> > VACUUM_ERRCB_PHASE_INDEX_CLEANUP. They can use PVIndVacStatus in the
> > error callback function as the patch does.
> >
>
> Okay. One minor point, let's change comments atop vacuum.c considering
> the movement of new functions.

Thank you for the comment. Agreed.

I've attached updated version patches. Please review them.

Regards,

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

Attachment Content-Type Size
v10-0001-Move-index-vacuum-routines-to-vacuum.c.patch application/octet-stream 19.0 KB
v10-0002-Move-parallel-vacuum-code-to-vacuumparallel.c.patch application/octet-stream 78.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Bille 2021-12-21 05:59:49 Re: [Proposal] Global temporary tables
Previous Message Ashutosh Sharma 2021-12-21 05:46:51 Re: Multi-Column List Partitioning