Set access strategy for parallel vacuum workers

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie>, Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>
Subject: Set access strategy for parallel vacuum workers
Date: 2021-04-07 10:00:15
Message-ID: CAA4eK1KbmJgRV2W3BbzRnKUSrukN7SbqBBriC4RDB5KBhopkGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Attachment Content-Type Size
fix_access_strategy_workers_1.patch application/octet-stream 3.6 KB
fix_access_strategy_workers_11.patch application/octet-stream 838 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2021-04-07 10:01:37 Re: New IndexAM API controlling index vacuum strategies
Previous Message David Rowley 2021-04-07 09:53:19 Re: Wired if-statement in gen_partprune_steps_internal