Presented by:

915d523d97a9a15e73120b8d7c41bbe5

Sachin Kotwal

from 2ndQuadrant

PostgreSQL Lover!!

No video of the event yet, sorry!

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:
Duration:
40 min
Room:
Conference:
PGConf India, 2020
Language:
Track:
Database Administration
Difficulty:
Medium