Seems like you'd also need to think about priority inversion, if the
low-priority backend is holding any locks.
I'm not sure that priority inversion would be right in this scenario,
because in that case the IO storm would still be able to exist, in the cases
where the slow jobs collide with
Eduardo Piombino wrote:
In the case where priority inversion is not to be used, I would
however still greatly benefit from the slow jobs/fast jobs mechanism,
just being extra-careful that the slow jobs, obviously, did not
acquire any locks that a fast job would ever require. This alone would