Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward

Dimitrios Apostolou <jimis@gmx.net>

View thread View on postgr.es

From: Dimitrios Apostolou <jimis@gmx.net>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: pgsql-hackers@lists.postgresql.org, Nathan Bossart <nathandbossart@gmail.com>

Date: 2025-06-09T20:09:57Z

Lists: pgsql-hackers

Attachments

v3-0001-parallel-pg_restore-avoid-disk-seeks-when-moving-.patch (text/x-patch) patch v3-0001

Attached now...

On Mon, 9 Jun 2025, Dimitrios Apostolou wrote:

>
>
> On Mon, 14 Apr 2025, Tom Lane wrote:
>
>>
>>  You should add your patch to the July commitfest [1] to make sure
>>  we don't lose track of it.
>
> I rebased the patch (attached) and created an entry in the commitfest:
>
> https://commitfest.postgresql.org/patch/5809/
>
>
> Thanks!
> Dimitris
>
>
>

Commits

Avoid short seeks in pg_restore.
- fba60a1b107d 19 (unreleased) landed
Don't rely on zlib's gzgetc() macro.
- 277dec651472 19 (unreleased) cited
Add more TAP test coverage for pg_dump.
- 20ec9958921a 19 (unreleased) landed
Split 002_pg_dump.pl into two test files.
- 9dcf7f1172cd 19 (unreleased) landed
Align the data block sizes of pg_dump's various compression modes.
- 66ec01dc4124 19 (unreleased) landed
Fix serious performance problems in LZ4Stream_read_internal.
- 1f8062dd9668 19 (unreleased) landed
Fix poor buffering logic in pg_dump's lz4 and zstd compression code.
- fe8192a95e6c 19 (unreleased) landed
Fix issue with reading zero bytes in Gzip_read.
- bf18e9bd70de 17.7 landed
- a239c4a0c226 19 (unreleased) landed
- 6a4009747c36 18.1 landed
- 1518b7d76aad 16.11 landed
Restore test coverage of LZ4Stream_gets().
- eac2b1697d48 17.7 landed
- 661b320ed4e0 18.1 landed
- 26d1cd375f15 19 (unreleased) landed