Presented by:

1f7511c5daf28a6d1a3519a086e67de3

Jobin Augustine

from Percona

Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 21 years of working experience as a 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, an active blogger and loves coding in C++ and Python. Jobin holds a Masters in Computer Applications and joined Percona in 2018. Previously, he worked at OpenSCG for two years as Architect and was part of the BigSQL core team. Jobin worked at Dell as Database Senior Advisor for ten years and five years with TCS/CMC.

Speaker at many conferences
PGConf India, Almost every year till 2020
postgresconf 2019
PerconaLive 2019
pgconf.Eu 2019

No video of the event yet, sorry!

PostgreSQL is the most advanced open-source database in terms of SQL processing capabilities. However, many users are unaware of the sheer power hiding inside its SQL engine and still write SQL-92 statements. With advanced SQL capabilities, much higher concurrency and performance can be achieved. This talk discusses some of the modern SQL techniques for developing applications with examples.

  • Implementation of data retention policy (archiving and purging) as a single statement.
  • Partitioning large tables without causing heavy wait locks or downtime.
  • Advanced uses of CTE - Complex transactions as a single statement.
  • Modern features like Merge and its use, such as replacing pl/pgsql procedures with single statements.
  • Cost of rollbacks and method to avoid

Date:
Duration:
45 min
Room:
Conference:
PGConf India, 2025
Language:
Track:
Application Developer
Difficulty:
Medium