Secure the future of MySQL. Sign this open letter

Modern SQL features in PostgreSQL that can transform the way we develop database applications

Location Bangalore, India
Dates Mar 5, 2025 – Mar 7, 2025
Presentation Mar 6, 2025 , 15:30
Speaker
Jobin Augustine
Jobin Augustine

PostgreSQL Escalation Specialist, Percona

Abstract

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

Video

Watch on YouTube: Modern SQL features in PostgreSQL that can transform the way we develop database applications

Speaker Bios

Jobin Augustine

PostgreSQL Escalation Specialist, Percona

Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 19 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.

See all talks by Jobin Augustine »

✎ Edit this page on GitHub