Download slides

Sharding in PostgreSQL

1. How to achieve Sharding in PostgreSQL

This section will give details of PostgreSQL Sharding prerequisite (required extensions and sample example).

• Sharding with inheritance based partitioning : Demo example for Sharding with inheritance based partitioning.

• Sharding with declarative partitioning : Demo example for Sharding with inheritance based partitioning.

• Existing other PostgreSQL sharding solutions : Talk about existing sharding solutions.

2. How can we achieve auto Sharding

Explain how one can achieve auto Sharding using plpgsql based functions.

3. Benefits of Sharding in PostgreSQL

Talk about common benefits of sharding in PostgreSQL

4. Limitations of Sharding in PostgreSQL

Discuss about current limitations of Sharding in PostgreSQL.

5. Good use cases for Sharding

Discuss few use cases where sharding gives performance benefits