I have an application that uses postgres database on one region (US West) containing several tables, one of which contains several hundred thousand records (let’s call it “events” table with “eventId” as the primary key/Integer/auto-increment)
I also recently cloned this database into another region (EU central) for users using the application on that region.