Re: Parallel heap vacuum

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Melanie Plageman <melanieplageman(at)gmail(dot)com>
Cc: John Naylor <johncnaylorls(at)gmail(dot)com>, Tomas Vondra <tomas(at)vondra(dot)me>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Parallel heap vacuum
Date: 2025-03-03 09:28:57
Message-ID: CAD21AoDhpqngBasGGi9ODQpGoG01GAbxdCOVxRM+j5GPreJrSA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Feb 25, 2025 at 4:49 PM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>
> On Tue, Feb 25, 2025 at 2:44 PM Melanie Plageman
> <melanieplageman(at)gmail(dot)com> wrote:
> >
> > On Tue, Feb 25, 2025 at 5:14 PM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
> > >
> > > Given that we have only about one month until the feature freeze, I
> > > find that it's realistic to introduce either one parallelism for PG18
> > > and at least we might want to implement the one first that is more
> > > beneficial and helpful for users. Since we found that parallel phase
> > > III is not very efficient in many cases, I'm thinking that in terms of
> > > PG18 development, we might want to switch focus to parallel phase I,
> > > and then go for phase III if we have time.
> >
> > Okay, well let me know how I can be helpful. Should I be reviewing a
> > version that is already posted?
>
> Thank you so much. I'm going to submit the latest patches in a few
> days for parallelizing the phase I. I would appreciate it if you could
> review that version.
>

I've attached the updated patches that make the phase I (heap
scanning) parallel. I'll share the benchmark results soon.

Regards,

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

Attachment Content-Type Size
v10-0005-Support-parallelism-for-collecting-dead-items-du.patch application/octet-stream 49.5 KB
v10-0004-Move-GlobalVisState-definition-to-snapmgr_intern.patch application/octet-stream 9.1 KB
v10-0002-vacuumparallel.c-Support-parallel-table-vacuumin.patch application/octet-stream 21.5 KB
v10-0003-Move-lazy-heap-scan-related-variables-to-new-str.patch application/octet-stream 30.8 KB
v10-0001-Introduces-table-AM-APIs-for-parallel-table-vacu.patch application/octet-stream 5.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2025-03-03 09:32:22 Re: Commit fest 2025-03
Previous Message Amit Kapila 2025-03-03 09:23:41 Re: Selectively invalidate caches in pgoutput module