Program for PGConf India, 2025

Unscheduled events
Nikhil Sontakke

Postgres: ServerLESS is more?
Serveless Postgres: How do we get there?

presented by Nikhil Sontakke from Microsoft

Serverless is the IN thing nowadays in database. Looks like the next technical evolution in databases. This talk will look at Serverless from a PostgreSQL perspective and will touch on the following aspects:

  • basic definition and consideration of serverless, why now, etc.
  • concept of compute PG node
  • we'd need to separate out the wal server activity
  • we'd need to separate out the rela...
more

Database Engine Developers
Evgenii Ivanov

Sharded and Distributed Are Not the Same: What You Must Know When PostgreSQL Is Not Enough

presented by Evgenii Ivanov from YDB

It's not a secret that PostgreSQL is extremely efficient and scales vertically well. At the same time, it’s not a secret that PostgreSQL scales only vertically, thus its performance is limited by the capabilities of a single server. Most Citus-like solutions allow to shard the database, but a sharded database is not distributed and does not provide ACID guarantees for distributed transactions. ...

more

Case Study
Bruce Momjian

Securing PostgreSQL From External Attack

presented by Bruce Momjian from EnterpriseDB

This talk explores the ways attackers with no authorized database access can steal Postgres passwords, see database queries and results, and even intercept database sessions and return false data. Postgres supports features to eliminate all of these threats, but administrators must understand the attack vulnerabilities to protect against them. This talk covers all known Postgres external attack...

more

Database Administration
Krishna Lodha

Accelerating API Development in PostgreSQL with PostgREST

presented by Krishna Lodha from Rotten Grapes

This talk offers an immersive exploration into the rapid development of APIs within PostgreSQL environments utilizing PostgREST. As organizations increasingly seek efficient means to expose their database resources as web services, PostgREST emerges as a powerful tool, enabling swift API creation directly from PostgreSQL schemas.

Through this talk, participants will delve into the fundamenta...

more

Application Developer
Shailesh K Mishra

PostgreSQL for Edge Computing: Optimizing Database Performance in IoT Environments

presented by Shailesh K Mishra from AWS

Abstract As IoT devices proliferate, the need for efficient data management at the edge becomes crucial. This session explores adapting PostgreSQL for edge computing scenarios, focusing on strategies for data synchronization, conflict resolution, and performance optimization in distributed IoT setups. Key Points

Challenges of database management in edge computing environments Configuring ...

more

Database Administration
Deepak Mahto

Accelerating PL/pgSQL Code Conversion on Migration from Another Database

presented by Deepak Mahto from DataCloudGaze Consulting

Most of the initial adopters of PostgreSQL are folks moving from another database and code conversion or PL/pgsql development is an critical path. In the session, I will walk through my curated learning I had moving 15+ enterprise customers and large code bases(> 1 million lines of codes) to PostgreSQL with PL/pgsql.

Topics to cover

  1. Subtle art of code conversion, conversion is art not...
more

Application Developer
pwright8088

Speaking and Community Involvement for the Introvert

presented by pwright8088 from Wright Database consulting

Let’s be serious, I understand 99% of the audience for a technical conference will be introverted. I’m not here to disagree with that, I'm here to talk about the introvert inside of me and how I quiet it just enough to truly improve my life. We will discuss why the idea of speaking and community involvement is important to you. If you think all you need is technical skills in this market the...

more

Case Study
Gaurav Kukreja

cbo_stat_dump : Reproduce those complex query planner issues without having to replicate customer data

presented by Gaurav Kukreja from Yugabyte

The CBO (Cost Based Optimizer) tries to find the most optimal execution plan for your query. Unfortunately, it often fails to find the best plan and picks a suboptimal plan instead. When this occurs on a large production deployment, debugging the issue becomes a challenge. The issue cannot easily be reproduced on a test setup without replicating the user data. Turns out, the CBO depends only on...

more

Application Developer
Shalaka Dengale Ramya Bhat

Building Scalable APIs: PostgreSQL Meets GraphQL

presented by Shalaka Dengale, Ramya Bhat from AWS

In today’s rapidly evolving application landscape, developers seek efficient and flexible ways to manage and query data. PostgreSQL and GraphQL integration provides a powerful combination, blending the robustness of a relational database with the flexibility of an API query language. This presentation explores how PostgreSQL can seamlessly integrate with GraphQL to create scalable, high-perform...

more

Application Developer
Varun Dhawan

Using Postgres to locate the best coffee near you!

presented by Varun Dhawan from Microsoft

Using Postgres to locate the best coffee near you!

The talk combines PostgreSQL with spatial and vector data to enable natural language queries for precise results, such as asking, "Where's the nearest coffee shop?" Vector data will be explained as a tool that enhances PostgreSQL's ability to manage geographical information. The session explores **how to integrate spatial and vect...

more

Application Developer
Joe Conway

Collation Challenges: Sorting it Out

presented by Joe Conway from AWS

Background: "libc" is commonly used as a shorthand for the "standard C library", a library of standard functions that can be used by all C programs. glibc is the GNU C Library implementation, which is used on all major Linux distributions (e.g. AL, RHEL, Debian/Ubuntu, SuSE). The glibc library, libc.so, provides most of the foundational C routines such as open, read, write, malloc, printf, and ...

more

Database Administration
tarask

PostgreSQL Security: From Attack Simulation to Defense

presented by tarask from SQL.ua

In today's digital age, understanding the potential threats to your PostgreSQL database and how to counteract them is crucial. This talk, 'PostgreSQL Security: From Attack Simulation to Defense', offers a comprehensive exploration of key external threats that PostgreSQL databases face.

We will start by examining real-world attack simulations to highlight the vulnerability of databases to var...

more

Database Administration
Vigneshwaran C

Understanding Write-Ahead Logging (WAL) in PostgreSQL

presented by Vigneshwaran C from Fujitsu

In this session, we will explore the critical role of Write-Ahead Logging (WAL) in PostgreSQL, a fundamental mechanism that ensures data integrity and durability. We will begin by discussing why WAL is essential for maintaining the consistency of database transactions.

Next, we will delve into the inner workings of WAL, examining how it records changes before they are applied to the main dat...

more

Database Engine Developers
Jobin Augustine

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

presented by Jobin Augustine from Percona

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. ...

more

Application Developer
Shlok Kyal

How to Upgrade Replication Clusters without Downtime?

presented by Shlok Kyal from Fujitsu

  • Overview of pg_upgrade
  • Overview of Replication in postgres
  • Upgrade of replication clusters in postgres until PG16
    • Challenges to upgrade streaming replication clusters.
    • Why use logical replication to upgrade streaming replication clusters?
    • Steps to upgrade streaming replication cluster
    • Steps to upgrade logical replication cluster
  • Problems during upgrade of ...
more

Application Developer
Atsushi Torikoshi

Be Good Friends with Query Planner: How to Get, Analyze, and Control Plans

presented by Atsushi Torikoshi from NTT

PostgreSQL's planner is our excellent colleague. When we write SQL queries, the planner devises the optimal plans to get the results.

Unfortunately, just as there is no perfect human, the planner sometimes selects suboptimal plans. Consequently, the query execution takes a long time and we DBAs are woken up by phone calls in the middle of the night to know the chosen plan.

Getting the pla...

more

Database Administration
Rakesh Raghav Gokul Gunasekaran Sawan Saxena

Being mindful of query optimizer differences between postgresql, Oracle and Db2 luw

presented by Rakesh Raghav, Gokul Gunasekaran, Sawan Saxena from AWS

In this talk we will Discusses how each of these database systems approaches query optimization differently. It emphasizes the importance of understanding these differences for effective database performance tuning and application development. Key points typically include:

  • Optimizer Strategies: Each database uses distinct algorithms and strategies for optimizing queries. PostgreSQL ...
more

Database Administration
Nisha Moond

Failover Slots in PostgreSQL-17: Ensuring High Availability with Logical Replication

presented by Nisha Moond from Fujitsu

  • Enhancing High Availability: Failover slots in PostgreSQL-17 enable seamless continuation of logical replication during publisher node failure, with a promoted physical standby taking over as the new publisher.
  • How Failover Slots Work:
    • Fetching and synchronizing logical replication slot information from the primary to the standby.
    • Manual synchronization using the pg_sync...
more

Database Administration
Ashutosh Bapat

Graph databases, PostgreSQL and SQL/PGQ

presented by Ashutosh Bapat from Microsoft

Graph databases are a major database paradigm next to relational databases, object databases, document databases and so on. There are popular DBMSes exclusively focusing on graph databases, DBMSes from other paradigms, including traditional SQL as well as NoSQL, have begun to extend their products with graph data capabilities and interfaces. SQL/PGQ was introduced as Part 16 of SQL standard in...

more

Application Developer
Bharath Kumar Pammi Ramesh Chethan G

PostgreSQL 17's Login Event Triggers: A Developer's Toolkit for Enhanced Security

presented by Bharath Kumar Pammi Ramesh, Chethan G from AWS

PostgreSQL 17 *introduces a powerful new feature: *Login Event Triggers.

This capability allows developers to execute custom code when users connect to a database, opening up new possibilities for** security, auditing, and session management. **

Talk will cover 1.Login Event Triggers can be used to implement sophisticated access controls, log connection attempts, initialize ses...

more

Database Engine Developers
Ujjwal Gupta

Postgres as a Message Broker to handle asynchronous task at scale

presented by Ujjwal Gupta from SquadStack

This proposal outlines how to use PostgreSQL as a message broker, addressing memory issues encountered with AmazonMQ and observability limitations in Redis. The system design incorporates a robust database schema, efficient worker processes, and additional features for task scheduling and management. Key components include:

Database Schema: Utilizes tables for queues, tasks, task instances,...

more

Application Developer
Pavan Deolasee

Beginner's guide to PostgreSQL Hacking

presented by Pavan Deolasee from EDB

PostgreSQL is world's most popular database and its popularity is only growing with time. A lot of companies are on constant lookout for PostgreSQL hackers and the demand is still more than the supply. So if you're a C developer and want to make a career as a PostgreSQL developer and simply start contributing to PostgreSQL, this talk will provide a basic introduction to PostgreSQL's development...

more

Database Engine Developers
Amit Langote

Hacking Postgres Executor For Performance

presented by Amit Langote from Microsoft

PostgreSQL’s executor currently relies on the Volcano (iterator-based) execution model, processing one tuple at a time in a pull-based approach. While this design offers flexibility and ease of integration, it can introduce significant overhead for large-scale analytical queries, where the cost of per-tuple function calls becomes a bottleneck. Other execution models, such as vectorized executio...

more

Database Engine Developers
Pavlo Golub

When it all GOes right

presented by Pavlo Golub from Cybertec

This talk covers how to use PostgreSQL together with the Golang (Go) programming language. I will describe what drivers and tools are available and which to use nowadays.

In this talk I will cover what design choices of Go can help you to build robust programs. But also, we will reveal some parts of the language and drivers that can cause obstacles and what routines to apply to avoid risks. ...

more

Application Developer
Sonia Valeja

pgBackRest: Elevating PostgreSQL Backup Game

presented by Sonia Valeja from Percona

In the world of PostgreSQL database management, ensuring robust and efficient backup strategies is crucial for maintaining data integrity and availability. pgBackRest, a powerful open-source tool, has become the preferred solution for many organizations seeking a comprehensive and flexible backup system. This talk, titled "pgBackRest: Elevating Your PostgreSQL Backup Game", introduces database ...

more

Database Administration
Shivji Kumar Jha

Pushing PostgreSQL to the Limits: Tackling Analytics Workloads with Extensions

presented by Shivji Kumar Jha from Nutanix

PostgreSQL's popularity has surged in recent years, topping DB-Engines rankings and earning the most popular title on Stack Overflow. However, built primarily for OLTP workloads, Postgres can face challenges when handling complex analytics, queuing, and streaming. Traditionally, data is off...

more

Database Engine Developers
Ants Aasma

Things your explain plan is not telling you

presented by Ants Aasma from Cybertec

As much as we all love PostgreSQL explain command for diagnosing performance issues, there are some things that it doesn't reveal to us. In this talk I will take a look at some of the hidden performance gremlins and how to spot them in your plans. Things like TOAST lookups, visibility checks, hint bits and expression evaluation time can sometimes turn up in surprising places in your execution p...

more

Application Developer
Kevin Biju

A lesser known Superpower of Postgres Logical Replication: Protocol Versions

presented by Kevin Biju from Clickhouse

Did you know that Logical Replication has four protocol versions, each adding more features to the Postgres Logical Replication protocol, from drastically impacting performance to supporting more complex SQL commands?

In this talk, we will take a deep dive into each of these protocol versions and explore the use cases where they make sense, from the perspective of both Postgres and an extern...

more

Database Administration
Claire Giordano

Beginner's Guide to Partitioning vs. Sharding in Postgres

presented by Claire Giordano from Microsoft

Partitioning has come a long way in Postgres since the Postgres 10 days, as has sharding via the Citus extension. If you need to scale your Postgres, your friends may recommend you look into partitioning and/or sharding. But what’s the difference between these two approaches?

This beginner’s guide is for those who want to start with the basics and advance from there. You’ll learn what partit...

more

Database Administration
Hannu Krosing

Extending your database server's abilities in a safe and powerful way

presented by Hannu Krosing from Google

PostgreSQL is build from ground up on extensibility.

Some of it can be done by writing database functions in pl/pgsql or plain SQL but sometimes you need to do more complex thing in highly performant way. For many of these needs implementations of complex algorithms are already available as open source, so all that is needed is packaging them as PostgreSQL extensions and this has been going...

more

Application Developer
Anup Sharma Mehboob Alam

Performance is a feature: accelerating Postgres system performance with PL/Rust

presented by Anup Sharma, Mehboob Alam from Nutanix

As applications grow in complexity, the choice of implementation language and the level at which algorithms are executed can significantly impact performance. Better designed and performing systems can also lead to significantly reduced infrastructure costs and energy consumption. This is an important consideration in your career path to becoming senior engineers and architects. This talk prese...

more

Application Developer
Gunjan Juyal

Scaling Semantic Search in PostgreSQL : Indexing and Searching at Scale with pgvector

presented by Gunjan Juyal from Google

Summary

Vector databases are revolutionizing information-retrieval applications by bridging the semantic-information unlocked by LLMs to the power and convenience of semantic query search. But efficiently managing and querying vector embeddings within a relational database like PostgreSQL requires specialized knowledge, especially when talking about the scale and accuracy expected in a p...

more

Application Developer
Yugank Srivastava

“AI-Assisted Post-Mortem Analysis and Optimizations for PostgreSQL Performance”

presented by Yugank Srivastava from Brightly

AI-Assisted Post-Mortem Analysis and Optimizations for PostgreSQL Performance

Abstract For database administrators (DBAs), resolving PostgreSQL performance issues is a time-sensitive task that traditionally relies on manual log reviews and system analysis. This paper presents a concise approach to using AI for post-mortem analysis, enabling faster identification of failure patterns and root...

more

Database Administration
Amit Thakur

Harnessing GIS capability of PostgreSql using POSTGIS and OpenStreetMap (OSM) DATA

presented by Amit Thakur from Michelin

The PostgreSQL database server, with the PostGIS extension, supports storing and managing geospatial data such as points, lines, and polygons. This capability enables effective interaction with and analysis of GIS data. For example, it can ingest OpenStreetMap (OSM) data, which can then be visualized on maps or used in various applications. These applications include understanding driving patte...

more

Application Developer
HariKrishna Rajesh Madiwale

PostgreSQL at Scale: Database Schema Changes With Minimal/No-Downtime

presented by HariKrishna, Rajesh Madiwale from AWS

Join us for a comprehensive 3-hour training course designed to help you get started with active-active distributed PostgreSQL deployments. The session will include design principles as well as exercises using pre-built data from pgBench (with Spock) and Northwind database.

Throughout this session, you will learn how to achieve bi-directional replication at both the table and schema levels ac...

more

Training
Franck Pachot Gaurav Kukreja

Query Optimization Workshop: Practical Examples, Methods and Tools

presented by Franck Pachot, Gaurav Kukreja from Yugabyte

In this workshop, we will explore SQL query optimization specifically for PostgreSQL. Participants will learn to interpret execution plans and understand how different SQL writing styles can affect query planner optimizations. In addition to core PostgreSQL features, the session will cover external tools for plan visualization and the pg_hint_plan extension for exploring alternative execution p...

more

Training
Hari Kiran Cady Motyka

Getting started with active-active Distributed PostgreSQL

presented by Hari Kiran, Cady Motyka from PgEdge

Join us for a comprehensive 3-hour training course designed to help you get started with active-active distributed PostgreSQL deployments. The session will include design principles as well as exercises using pre-built data from pgBench (with Spock) and Northwind database.

Throughout this session, you will learn how to achieve bi-directional replication at both the table and schema levels ac...

more

Training
Deepak Mahto

PostgreSQL PL/pgSQL Development Deep Dive

presented by Deepak Mahto from DataCloudGaze Consulting

We will conduct core foundation and considerations when building business logic using PL/pgSQL in PostgreSQL. Session will help application developers to build enterprise scale apps for business critical applications.

In the session we will cover following with samples to try out together as part of on-going trainings.

  1. PL/pgSQL Foundations
  2. What is Dollar Quoting and How PL/pgSQL Co...
more

Training
Bhargav kamineni Sagar Jadhav

Mastering PostgreSQL Logical Replication: Introduction, Setup, Failures, and Best Practices

presented by Bhargav kamineni, Sagar Jadhav from Percona

Training coverage: 1. Introduction to Logical Replication - Overview of PostgreSQL replication options: physical vs. logical - Benefits and use cases for logical replication - How logical replication fits into PostgreSQL's architecture

  1. Setting Up Logical Replication
    • Prerequisites and environment setup
    • Configuring publisher and subscriber
    • Step-by-step guide o...
more

Training
Shriram Muthukrishnan

Developing RAG Apps with Azure Database for PostgreSQL & LangChain

presented by Shriram Muthukrishnan from Microsoft

Join us for an immersive 3-hour training session where you will learn to build a Retrieval-Augmented Generation (RAG) application leveraging PostgreSQL’s open-source pgvector extension, the new DiskANN extension, LangChain, and Python Jupyter Notebooks. This session will guide you through integrating vector search capabilities on Azure Database for PostgreSQL, using LangChain for advanced text ...

more

Training
Gunjan Juyal Saurabh Gupta

Pgvector - from Prototype to Production

presented by Gunjan Juyal, Saurabh Gupta from Google

Using pgvector to build innovative ANN vector-search applications can be an overwhelming experience due to the complexities involved. This training explores techniques to productionize pgvector workloads and build GenAI applications using PostgreSQL, and provides hands-on experience with the most common techniques.

We will cover the following key areas: Estimating the optimal server configu...

more

Training
Danish Khan

Introduction to PostgreSQL in Kubernetes with CloudNativePG

presented by Danish Khan from EDB

Join us for an intensive training session designed for professionals aiming to enhance their expertise in managing PostgreSQL databases within Kubernetes environments using the CloudNativePG operator.

Training
Abhijeet Rajurkar

A Comparative Analysis of Vector Indexing Techniques in PostgreSQL
A Comparative Analysis of Vector Indexing Techniques in PostgreSQL

presented by Abhijeet Rajurkar from Google

Synopsis: This paper provides insights into the performance characteristics of IVF-HNSW, IVFFlat, and SCAAN indexing techniques for vector data in PostgreSQL. By understanding the trade-offs in accuracy, speed, and resource consumption, users can select the optimal indexing strategy for their specific application needs. In this session we also talk about a comparative analysis of three leadin...

more

Database Administration