On 9/4/24 08:46, Bertrand Drouvot wrote:> What about moving the tests to
places where it's "guaranteed" to get
> parallel workers involved? For example, a "parallel_maint_workers" only test
> could be done in vacuum_parallel.sql.
Thank you ! I was too focussed on the stat part and missed the obvious.
It's indeed better with this file.
... Which led me to discover that the area I choose to gather my stats
is wrong (parallel_vacuum_end), it only traps workers allocated for
parallel_vacuum_cleanup_all_indexes() and not
parallel_vacuum_bulkdel_all_indexes().
Back to the drawing board...
--
Benoit Lobréau
Consultant
http://dalibo.com
