> They're not even running Postgres, but AWS Aurora

But everything described is also PostgreSQL compatible.

> downtime

Context switching pauses execution too FYI.