PostgreSQL 12 High Availability Cookbook - Third Edition

Creating a scalable nextval replacement

Now that we have all of the tools to communicate between disparate servers, we can start building a very rudimentary API to generate ID values that are distinct across a pool of database servers. By doing so, database-level function calls are available to the application and encourage data distribution, otherwise known as application-level sharding. This, in turn, increases our scalability and availability, as it will take far more than a single database outage to truly derail the application.

A company that did this early in the development cycle of its platform is Instagram. In fact, they're very open about the process they used, as described in their blog post at https://instagram-engineering.com/sharding-ids-at-instagram-1cf5a71e5a5c ...