Re: small improvement of the elapsed time for truncating heap in vacuum

From: Kasahara Tatsuhito <kasahara(dot)tatsuhito(at)gmail(dot)com>
To: Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: small improvement of the elapsed time for truncating heap in vacuum
Date: 2020-02-17 05:28:34
Message-ID: CAP0=ZVJ0iJ7+8-5HMjFZb=K_mVhOh0L=hdfZfGMSA2hmV+LhmA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Mon, Feb 17, 2020 at 1:07 PM Masahiko Sawada
<masahiko(dot)sawada(at)2ndquadrant(dot)com> wrote:
> For the patch, we can put also the declaration of ru0 into the loop.
Thanks for your reply.
Hmm, certainly that it may be better.

Fix the v2 patch and attached.

Best regards,

--
Tatsuhito Kasahara
kasahara.tatsuhito _at_ gmail.com

Attachment Content-Type Size
reset_usage_v3.patch application/octet-stream 864 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2020-02-17 05:31:42 Re: ALTER tbl rewrite loses CLUSTER ON index (consider moving indisclustered to pg_class)
Previous Message Masahiko Sawada 2020-02-17 05:18:11 Re: error context for vacuum to include block number