Re: Speedup truncations of temporary relation forks

From: Maxim Orlov <orlovmg(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
Cc: Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>, Daniil Davydov <3danissimo(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Speedup truncations of temporary relation forks
Date: 2025-06-04 14:43:37
Message-ID: CACG=ezZF1JVu3+W0P3=vr+TKGKt+NFtnyktgnuKsFSCh=KF_qw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 4 Jun 2025 at 16:18, Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)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.

--
Best regards,
Maxim Orlov.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2025-06-04 14:52:38 Re: fix notes about password encryption in pg_authid docs
Previous Message Álvaro Herrera 2025-06-04 14:38:32 Re: Add tab-completion for ALTER TABLE ADD NOT NULL