Re: Parallel heap vacuum

From: Tomas Vondra <tomas(at)vondra(dot)me>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: "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-01-19 15:50:49
Message-ID: 44bce1dd-3ad8-4f34-9c5b-4499fd29433d@vondra.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Thanks for the new patches. I've repeated my benchmarking on v8, and I
agree this looks fine - the speedups are reasonable and match what I'd
expect on this hardware. I don't see any suspicious results like with
the earlier patches, where it got much faster thanks to the absence of
SKIP_PAGE_THRESHOLD logic.

Attached is the benchmarking script, CSV with raw results, and then also
two PDF reports comparing visualizing the impact of the patch by
comparing it to current master.

* parallel-vacuum-duration.pdf - Duration of the vacuum, and duration
relative to master (green - faster, read - slower). The patch is clearly
an improvement, with speedup up to ~3x depending on the index count and
a fraction of updated rows.

* parallel-vacuum-reads.pdf - Average read speed, as reported by VACUUM
VERBOSE. With the patch it can reach up to ~3GB/s, which is about the
max value possible on this hardware - so that's nice. I'll try to test
this on a better storage, to see how far it can go.

I haven't done any actual code review on the new patches, I'll try to
find time for that sometime next week.

regards

--
Tomas Vondra

Attachment Content-Type Size
parallel-vacuum.csv text/csv 127.6 KB
create-small-unlogged.sql application/sql 406 bytes
create-small-logged.sql application/sql 397 bytes
paralle-vacuum.sh application/x-shellscript 5.1 KB
parallel-vacuum-duration.pdf application/pdf 21.2 KB
parallel-vacuum-reads.pdf application/pdf 21.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-01-19 17:02:05 Re: New feature request for adding session information to PostgreSQL transaction log
Previous Message Yura Sokolov 2025-01-19 14:56:49 Re: [RFC] Lock-free XLog Reservation from WAL