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 |
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 |