Re: Resume vacuum and autovacuum from interruption and cancellation

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: Resume vacuum and autovacuum from interruption and cancellation
Дата
Msg-id CAD21AoDHOFGFc+PxZd20SPKNtRt=mdHoxpMRHgapy7aDTyyS5w@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Resume vacuum and autovacuum from interruption and cancellation  ("Jamison, Kirk" <k.jamison@jp.fujitsu.com>)
Ответы Re: Resume vacuum and autovacuum from interruption and cancellation  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: refactoring - share str2*int64 functions
Следующее
От: "Moon, Insung"
Дата:
Сообщение: Wrong value in metapage of GIN INDEX.