If that's the underlying issue, sequentiallity... Just use uuid uuid 6 or 7. They are time based and approximately sortable (unlike uuid1). https://datatracker

If that's the underlying issue, sequentiallity... Just use uuid uuid 6 or 7. They are time based and approximately sortable (unlike uuid1). https://datatracker.ietf.org/doc/html/draft-peabody-dispatch-new-uuid-format#section-4.1 https://datatracker.ietf.org/doc/html/draft-peabody-dispatch... Disclaimer, I have no data to back up this solves the performance problems described. It's just likely to solve that "writing in the middle of the table" part.