I think this will be resolved through locality. During initial and catch-up sync, organization starts once there is a stronger candidate chain, and that evaluation (download/validation/confirmability) starts once there is a current header chain. This results in a cascade of single block organizations, since the next block in order is always a stronger chain than that previously confirmed.
Consequently with concurrent validation/confirmation the same inputs/outputs/prevouts and indexes will already be paged in as a consequence of full block and prevout population. This makes navigating the links for confirmability almost free and should preclude paging. The only additional searches, reads and writes are to the strong_tx table, however this is a small table (tx scale with little data) that should not cause thrashing.
So instead of running confirmation in series it makes a lot more sense to run it concurrently, and instead to run download and validation/confirmability in series.