During recent developments in the vacuum, it has been noticed [1] that parallel vacuum workers don't use any buffer access strategy. I think we can fix it either by propagating the required information from the leader or just get the access strategy in each worker separately. The patches for both approaches for PG-13 are attached.
Thoughts? [1] - https://www.postgresql.org/message-id/CAH2-Wz%3Dgf6FXW-jPVRdeCZk0QjhduCqH_XD3QbES9wPmhircuA%40mail.gmail.com -- With Regards, Amit Kapila.
fix_access_strategy_workers_1.patch
Description: Binary data
fix_access_strategy_workers_11.patch
Description: Binary data