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