Presented by:

1f7511c5daf28a6d1a3519a086e67de3

Jobin Augustine

from Percona

Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 18 years of working experience as consultant, architect, administrator, writer, and trainer in PostgreSQL, Oracle and other database technologies. He has always been an active participant in the Open Source communities and his main focus area is database performance and optimization. He is a contributor to various Open Source Projects and is an active blogger and loves to code in C++ and Python. Jobin holds a Masters in Computer Applications and joined Percona in 2018 as a Senior Support Engineer. Prior to joining Percona, he worked at OpenSCG for 2 years as Architect and was part of the BigSQL core team, a complete PostgreSQL distribution offering. Previous to his work at OpenScg, Jobin worked at Dell as Database Senior Advisor for 10 years and 5 years with TCS/CMC.

Speaker at: postgresconf 2019 PerconaLive 2019 pgconf.Eu 2019

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

Date:
2019 February 14 - 14:45
Duration:
45 min
Room:
Ballroom 4
Conference:
PGConf India, 2019
Language:
Track:
Database Engine Developer
Difficulty:
Intermediate

Happening at the same time:

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

    Room:
    Ballroom 3

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

    Room:
    Ballroom 1