Presented by:

915d523d97a9a15e73120b8d7c41bbe5

Sachin Kotwal

from 2ndQuadrant

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

Happening at the same time:

  1. PostgreSQL: Pushing the limits on a single machine
  2. Start Time:
    2020 February 28 11:00

    Room:
    Grand Victoria 2

  3. Top 10 Mistakes When Migrating From Oracle to PostgreSQL
  4. Start Time:
    2020 February 28 11:00

    Room:
    Grand Victoria 1