About

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.


Jobin Augustine has presented the following presentations

    Jobin Augustine Power use of Indexes in PostgreSQL - A user perspective. at 2021 Postgres Conference Webinars
    Understand the real use of each index types and the ways in which they can be utilized.

    presented by Jobin Augustine


    video

    There have been many presentations about the Different Indexes in PostgreSQL ( B-Tree, HASH, GIN, GiST etc), especially from the architecture perspective. But these talks always lacked details from the user perspective on the selection of indexes.
    It is common to see that architects and developers fail to select the right types of index and the way it should be used.
    Just an overview of ...

    more

    Wed 1 2021 Ops
    Jobin Augustine Evolution of Partitioning Features in PostgreSQL - A super charged elephant at 2021 Postgres Conference Webinars
    Important milestones in Partitioining features and how it evolved over a time to become one of the most powerful feature.

    presented by Jobin Augustine

    The Partitioning features in PostgreSQL is not something new. But it has matured over several years, release after release, especially the last 4 releases.
    The evolutionary nature (small changes in each version) is often overlooked by users.
    These small changes resulted in a build-up of a powerful Partitioning capability in PostgreSQL new versions. Now it is considered as capable of even...

    more

    Tue 14 2021 Ops
    Jobin Augustine Deeper Understanding of PostgreSQL Execution Plan: At plan time and run time at Postgres Webinar Series

    presented by Jobin Augustine


    video

    Right execution plans can deliver maximum performance and throughput from your PostgreSQL database. It is important to understand all factors which affect the execution plan which includes costing, datatypes, indexing, filter and join conditions, pruning, runtime exclusions, etc. Poor understanding of the planner leads to suboptimal performance. There are substantial improvements in new vers...

    more

    Tue 30 2020 Ops
    Jobin Augustine Interesting 25 new features in PostgreSQL 12 at Postgres Conference 2020
    Why PostgreSQL version 12 is the turning point and why enterprise customers should adopt it.

    presented by Jobin Augustine

    PostgreSQL 12 made a giant leap in many of the areas of PostgreSQL which includes partitioning, query planner, Indexing and some SQL features, etc. Among all of the interesting features for developers and admins, we shall be discussing 25 of the most interesting features with some good examples and benchmarks done This talk includes: - Partitioning improvements - Indexing Improvements 3. S...

    more

    Ops and Administration
    Jobin Augustine Why PostgreSQL is Becoming a Migration Target in Large Enterprises at Postgres Conference 2020
    Reasons behind the rapid growth in adpoption and migration to PostgreSQL

    presented by Jobin Augustine

    This talk contains deeper analysis of compelling reasons why large enterprises opted to migrate to PostgreSQL. Every layer of enterprise, Executive management, Architects, Developers, and Operations team finds multiple strong reasons for selecting PostgreSQL. This is changing the PostgreSQL user-base and landscape. In other words, This talk is about why someone should migrate to PostgreSQL. T...

    more

    Case Studies
    Jobin Augustine Deeper Understanding of PostgreSQL Execution Plan : At plan time and run time at Postgres Conference 2020
    smart planner in postgresql

    presented by Jobin Augustine

    Right execution plans can deliver maximum performance and throughput from your PostgreSQL database. It is important to understand all factors which affect the execution plan which includes costing, datatypes, indexing, filter and join conditions, pruning, runtime exclusions, etc. Poor understanding of the planner leads to suboptimal performance. There are substantial improvements in new version...

    more

    Development