Data Distribution

In this chapter, we will learn how clever data management can increase uptime even further. We will cover the following recipes in this chapter:

• Identifying horizontal candidates
• Setting up a foreign PostgreSQL server
• Mapping a remote user
• Creating a foreign table
• Using a foreign table in a query
• Optimizing foreign table access
• Transforming foreign tables into local tables
• Creating a scalable nextval replacement
• Building a sharding API
• Talking to the right shard
• Moving a shard to another server