Modern SQL features in PostgreSQL that can transform the way we develop database applications
Presented by:
Jobin Augustine
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