Presented by:


Jobin Augustine

from Percona

Jobin Augustine has an overall experience of 17 years in PostgreSQL, Oracle, MySQL databases technologies. He has always been an active participant in the OpenSource communities, especially database communities and as an OpenSource advocate. He is a contributor to various OpenSource Projects and he loves to code in C++ and Python in his free time. He worked for OpenSCG for 2 Years and Dell for 10 years as a Database expert previously.

No video of the event yet, sorry!

Download slides

  • Historically PostgreSQL was not known for features available for horizontal scalability in handling large data sets. As a result, many PostgreSQL based systems were designed to handle specific types of business cases. But the PostgreSQL as its core was a bit lagging behind. Things started changing over a period of time. New methods and features like partitioning, sharding, FDWs started emerging. This presentation is about smarter choices available today and the major points to be considered for choosing them while architecting an Application.

  • This presentation Includes

    • 1. A closer look at scalability in the database world.
    • 2. Why divide and conquer is the right approach.
    • 3. New partitioning features in PostgreSQL
    • 4. How to partition data across multiple PostgreSQL servers.
    • 5. Advanced extensions available for PostgreSQL - Citus Data and TimescaleDB etc.
    • 6. Smart use of FDWs - Data from other data sources

2019 February 14 - 14:45
45 min
Ballroom 4
PGConf India, 2019
Database Engine Developer

Happening at the same time:

  1. Knowing your data cluster and startup processes
  2. Start Time:
    2019 February 14 14:45

    Ballroom 3

  3. Restore your backups!
  4. Start Time:
    2019 February 14 14:45

    Ballroom 1