Hm, deadlocks preventing order by. Never had that problem. Then again, I mostly have Oracle experience and no need for complicatedupdates. If I had, I'd rather think of chunking updates and orchestrate those before ordering within updates.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
