Re: Unlinking Parallel Hash Join inner batch files sooner

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>, John Naylor <johncnaylorls(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Unlinking Parallel Hash Join inner batch files sooner
Date: 2026-01-27 06:59:11
Message-ID: DBEF9738-CD78-4DF2-A2BA-7B21B16B0566@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers!

> On 7 Oct 2024, at 12:05, Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>
> I am not seeing anything committed, either. Thomas, an update?

I was looking for something to review on the commitfest and decided that something 2+ y.o. is a best option.

The patch is correct and still applicable. The patch is an improvement that reduces temporary disk space usage during PHJ repartitioning.

Actual thread already contained enough feedback. So I decided to propose addressing of Heikki's feedback from September 2023 along with original patch (attached intact).

The patch is already marked as RfC and I agree that this status seems correct.

Best regards, Andrey Borodin.

Attachment Content-Type Size
v2-0001-Unlink-PHJ-temporary-files-proactively-when-repar.patch application/octet-stream 4.2 KB
v2-0002-Add-sts_delete_files-to-avoid-unnecessary-accesso.patch application/octet-stream 5.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2026-01-27 07:09:44 Re: Remove PG_MMAP_FLAGS
Previous Message Michael Paquier 2026-01-27 06:56:27 Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions