Program for PGConf India, 2025

presented by Varun Dhawan 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, Semantic Ranker, and GraphRAG. This session will guide you through integrating vector search capabilities on Azure Database for PostgreSQL. By the end of this workshop, you will have h...

presented by Hari Kiran 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...

presented by Rajesh Madiwale, HariKrishna from Amazon Web Services

"Database schema migrations can be a double-edged sword. They are essential for keeping our systems up to date and in sync with evolving application requirements, but often come bundled with a set of challenges that can give even the most seasoned developers and database administrators a nightmare. There's no one tool or a process to be followed for a seamless, minimal/no-downtime and risk free...

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

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.

presented by Franck Pachot, Gaurav Kukreja from MongoDB

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

presented by Rushabh Lathia, Dilip Kumar from EnterpriseDB India Pvt. Ltd.

Checkout the slides

Handling customer escalations in PostgreSQL environments requires a deep understanding of performance bottlenecks, data integrity challenges, and replication conflicts. When critical issues such as subtransaction cache overflow, slow vacuum and wraparound risks, data corruption, and replication conflicts arise, they can...

presented by Vigneshwaran C from Fujitsu

Checkout the slides

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

presented by Anup Sharma, Mehboob Alam from Nutanix

Checkout the slides

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

presented by Shlok Kyal from Fujitsu

Checkout the slides

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

presented by Joe Conway from AWS

Checkout the slides

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

presented by PGConf Organizers from PGConf India

Diamond Sponsor Hall by Google Cloud

presented by Shalaka Dengale, Ramya Bhat from AWS

Checkout the slides

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

presented by Chethan G, Bharath Kumar Pammi Ramesh from AWS

Checkout the slides

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

presented by Sonia Valeja from Percona

Checkout the slides

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

presented by Shriram Muthukrishnan from Microsoft

Diamond Sponsor Hall by Microsoft:

In this session, we will explore Azure Database for PostgreSQL – Flexible Server, a fully managed PostgreSQL service on Azure. Through live demos, we will highlight the key capabilities that set it apart from other offerings in the market.

Key topics include:

• Elasticity – Effortless compute scaling with near-zero downtime, independent storage and IO...

presented by Harish Perumal from IITM Pravartak

Checkout the slides

An understanding about PostgreSQL Pages, Buffer Cache and the "clock-sweep" Buffer Eviction Algorithm. This topic will introduce the buffer cache in PostgreSQL. It will then discuss how pages are cached in it and how victim buffer pages are evicted when needed. One of the techniques that will be specifically looked at ...

presented by Hemendra Sharma from Squadstack

Checkout the slides

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

presented by Jobin Augustine from Percona

Checkout the slides

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

presented by Pavan Deolasee from EDB

Checkout the slides

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

presented by PGConf Organizers from PGConf India

Platinum Sponsor Hall by IITM Pravartak

presented by Bruce Momjian from EnterpriseDB

Checkout the slides

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

presented by Varun Dhawan from Microsoft

Checkout the slides

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

presented by Puja Audhya, Rakesh Raghav from AWS

Checkout the slides

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

presented by Nikhil Sontakke from Microsoft

Checkout the slides

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

presented by Pat Wright from Wright Database consulting

Checkout the slides

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

presented by Leonid Albrekht from PostgresPro

Checkout the slides

Platinum Sponsor Hall by PostgresPro:

For a database, one of the biggest challenges these days is reliability. Today we will talk about our built-in solution for fault and disaster tolerance in Postgres Pro named Build in High-Availability - BiHA. Let's take a look at this functionality and compare it with other faul...

presented by Amul Sul from EnterpriseDB

Checkout the slides

The talk will cover why the order of columns in a table can matter in specific scenarios, affecting both performance and maintainability. It will highlight how placing fixed-length columns (e.g., INT, DATE) before variable-length columns (e.g., TEXT, BYTEA) can optimize memory alignment, reduce padding, and improve perf...

presented by Ants Aasma from Cybertec

Checkout the slides

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

presented by Amit Thakur from Michelin

Checkout the slides

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

presented by Yugank Srivastava from Brightly

Checkout the slides

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

presented by Claire Giordano from Microsoft

Checkout the slides

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

presented by Pavlo Golub from Cybertec

Checkout the slides

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

presented by Gunjan Juyal, Eeshan Gupta from Google

Checkout the slides

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

presented by Evgenii Ivanov from YDB

Checkout the slides

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