Request a Demo
Home   >   mailing lists

parallel autovacuum: Propagate track_cost_delay_timing to parallel workers - Mailing list pgsql-hackers

From Sami Imseih
Subject parallel autovacuum: Propagate track_cost_delay_timing to parallel workers
Date
Msg-id CAN12+YJZaALd3zMeKVVRTwcuY5_yDtR_vMPwWc8QNgeYxrn4Zg@mail.gmail.com
Whole thread
Responses Re: parallel autovacuum: Propagate track_cost_delay_timing to parallel workers
List pgsql-hackers
Tree view 
Hi,

Here is a small patch to propagate track_cost_delay_timing to parallel
autovacuum workers.  1ff3180ca01 propagates the cost-based delay
parameters via PVSharedCostParams but left this one out, so a worker keeps
the value it inherited at parallel start, and workers will not report
sleep time if the GUC is turned on mid-flight.

This only impacts delay reporting, but should be backpatched to 19 which
introduced parallel autovacuum.

CC Sawada-san and Zsolt since there is a related discussion in [1], though
that one is about throttling.

[1] https://www.postgresql.org/message-id/flat/CAN4CZFOZtEPwGQ6oa9LvHvN522zEp8h_dW9hHExSh7pVXofoKQ%40mail.gmail.com

--
Sami Imseih
Amazon Web Services (AWS)
Attachment

pgsql-hackers by date:

Previous
From: shihao zhong
Date:
Subject: Re: REPACK (CONCURRENTLY) can silently lose updates when the toast table is rewritten
Next
From: Viktor Holmberg
Date:
Subject: Re: ON CONFLICT DO SELECT returns rows hidden by a view