Re: Resume vacuum and autovacuum from interruption and cancellation - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: Resume vacuum and autovacuum from interruption and cancellation
Date
Msg-id CAD21AoDHOFGFc+PxZd20SPKNtRt=mdHoxpMRHgapy7aDTyyS5w@mail.gmail.com
Whole thread Raw
In response to RE: Resume vacuum and autovacuum from interruption and cancellation  ("Jamison, Kirk" <k.jamison@jp.fujitsu.com>)
Responses Re: Resume vacuum and autovacuum from interruption and cancellation  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On Tue, Aug 27, 2019 at 2:55 PM Jamison, Kirk <k.jamison@jp.fujitsu.com> wrote:
>
> On Monday, August 19, 2019 10:39 AM (GMT+9), Masahiko Sawada wrote:
> > Fixed.
> >
> > Attached the updated version patch.
>
> Hi Sawada-san,
>
> I haven't tested it with heavily updated large tables, but I think the patch
> is reasonable as it helps to shorten the execution time of vacuum by removing
> the redundant vacuuming and prioritizing reclaiming the garbage instead.
> I'm not sure if it's commonly reported to have problems even when we repeat
> vacuuming the already-vacuumed blocks, but I think it's a reasonable improvement.
>
> I skimmed the patch and have few comments. If they deem fit, feel free to
> follow, but it's also ok if you don't.

Thank you for reviewing this patch! I've attached the updated patch
incorporated all your comments and some improvements.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Attachment

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: refactoring - share str2*int64 functions
Next
From: "Moon, Insung"
Date:
Subject: Wrong value in metapage of GIN INDEX.