Jobin Augustine
Senior Support Engineer at Percona
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.
Power use of Indexes in PostgreSQL - A user perspective.
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 ...
Evolution of Partitioning Features in PostgreSQL - A super charged elephant
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...
Deeper Understanding of PostgreSQL Execution Plan: At plan time and run time
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
Interesting 25 new features in PostgreSQL 12
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
Why PostgreSQL is Becoming a Migration Target in Large Enterprises
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
Deeper Understanding of PostgreSQL Execution Plan : At plan time and run time
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