> As dead tuples continue to accumulate in the index, Postgres enters a hot loop as it searches the B-tree, comes up with an invisible tuple, and repeats the process again and again, surfacing empty-handed every time.
Postgres Job Queues & Failure By MVCC https://brandur.org/postgres-queues