Re: Speedup truncations of temporary relation forks

Fujii Masao <masao.fujii@oss.nttdata.com>

From: Fujii Masao <masao.fujii@oss.nttdata.com>

To: Maxim Orlov <orlovmg@gmail.com>

Cc: Yura Sokolov <y.sokolov@postgrespro.ru>, Daniil Davydov <3danissimo@gmail.com>, Michael Paquier <michael@paquier.xyz>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2025-07-04T00:10:31Z

Lists: pgsql-hackers


On 2025/06/04 23:43, Maxim Orlov wrote:
> 
> On Wed, 4 Jun 2025 at 16:18, Fujii Masao <masao.fujii@oss.nttdata.com <mailto:masao.fujii@oss.nttdata.com>> wrote:
> 
> 
>     Regardless, I think we should go ahead and apply the current patch.
> 
> 
> Yeah, it is definitely improving things. It turns out that I made almost the same
> patch for our fork of Postgres, commissioned by one of the clients dealing with
> truncation of huge amount of temp relations. Back in the days, it solves the
> problem for him. But then I utterly forgot to share it with the community.
> Shame on me.
> 
> Anyway, the patch looks good to me. Hope, it will be committed soon.

Patch pushed. Thanks, everyone!

Regards,

-- 
Fujii Masao
NTT DATA Japan Corporation

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Speed up truncation of temporary relations.
- 78ebda66bf26 19 (unreleased) landed
Speedup truncations of relation forks.
- 6d05086c0a79 13.0 cited