Horton

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

Kasahara Tatsuhito <kasahara.tatsuhito@gmail.com>

View thread View on postgr.es
From: Kasahara Tatsuhito <kasahara.tatsuhito@gmail.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2020-02-17T03:43:41Z
Lists: pgsql-hackers

Attachments

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

Commits

  1. Fix mesurement of elapsed time during truncating heap in VACUUM.