Postgres Pro
Downloads
Home   >   mailing lists

Re: small improvement of the elapsed time for truncating heap in vacuum - Mailing list pgsql-hackers

From Kasahara Tatsuhito
Subject Re: small improvement of the elapsed time for truncating heap in vacuum
Date
Msg-id CAP0=ZVKQRGN4-_b4Zqf=Prn4DYT6MxQFsJ8L9te_x3tphB+iuQ@mail.gmail.com
Whole thread Raw
In response to Re: small improvement of the elapsed time for truncating heap in vacuum  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: small improvement of the elapsed time for truncating heap in vacuum
List pgsql-hackers
Tree view 
Hi,

On Fri, Feb 14, 2020 at 4:50 PM Fujii Masao <masao.fujii@gmail.com> wrote:
> Regarding the patch, isn't it better to put pg_rusage_init() at the
> top of do loop block? If we do this, as a side-effect, we can get
> rid of pg_rusage_init() at the top of lazy_truncate_heap().
Thanks for your reply.
Yeah, it makes sense.

Attached patch moves pg_rusage_init() to the top of do-loop-block.

Best regards,
-- 
Tatsuhito Kasahara
kasahara.tatsuhito _at_ gmail.com
Attachment

pgsql-hackers by date:

Previous
From: Bryn Llewellyn
Date:
Subject: Re: jsonb_object() seems to be buggy. jsonb_build_object() is good.
Next
From: Justin Pryzby
Date:
Subject: Re: error context for vacuum to include block number