Sharding in PostgreSQL
Presented by:

Sachin Kotwal
PostgreSQL Lover!!
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
- Date:
- 2020 February 28 - 11:00
- Duration:
- 40 min
- Room:
- Robusta + Arabica
- Conference:
- PGConf India, 2020
- Language:
- Track:
- Database Administration
- Difficulty:
- Medium
- PostgreSQL: Pushing the limits on a single machine
- Start Time:
- 2020 February 28 11:00
- Room:
- Grand Victoria 2
- Top 10 Mistakes When Migrating From Oracle to PostgreSQL
- Start Time:
- 2020 February 28 11:00
- Room:
- Grand Victoria 1