Program for PGConf India, 2025

2025-03-05
08:00
PGConf Organizers

Conference Registration on Training Day
Conference Registration on Training Day

presented by PGConf Organizers from PGConf India

Conference Registration on Training Day

08:00 - 09:00 Grand Ballroom Other
09:00
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

09:00 - 12:30 Grand Ballroom 1 Training
Varun Dhawan

Developing RAG Apps with Azure Database for PostgreSQL & GraphRAG

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

more

09:00 - 12:30 Neptune Training
Hari Kiran

Getting started with active-active Distributed PostgreSQL

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

more

09:00 - 12:30 Grand Ballroom 2 Training
Rajesh Madiwale HariKrishna

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

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

more

09:00 - 12:30 Jupiter Training
13:00
PGConf Organizers

Training Day Lunch
Training Day Lunch

presented by PGConf Organizers from PGConf India

Training Day Lunch

13:00 - 14:00 Grand Ballroom 1 Other
14:00
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

14:00 - 17:30 Neptune 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

14:00 - 17:30 Grand Ballroom 2 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.

14:00 - 17:30 Jupiter Training
Franck Pachot Gaurav Kukreja

Query Optimization Workshop: Practical Examples, Methods and Tools

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

more

14:00 - 17:30 Grand Ballroom 1 Training
19:00
PGConf Organizers

Invitation-Only Dinner on 5th March, 2025
Invitation-Only Dinner on 5th March, 2025

presented by PGConf Organizers from PGConf India

Invitation-Only Dinner on 5th March, 2025

19:00 - 22:00 Grand Ballroom Other
2025-03-06
08:00
PGConf Organizers

Conference Registration on Day 1 - 6th March 2025
Conference Registration on Day 1 - 6th March 2025

presented by PGConf Organizers from PGConf India

Conference Registration on Day 1 - 6th March 2025

08:00 - 09:00 Grand Ballroom Other
09:00
PGConf Organizers

Opening Remarks
Opening Remarks

presented by PGConf Organizers from PGConf India

Opening Remarks

09:00 - 09:15 Grand Ballroom Other
09:15
Peter Zaitsev

PostgreSQL and the Future of Open Source Databases
PostgreSQL and the Future of Open Source Databases

presented by Peter Zaitsev from Percona

Checkout the slides

2024 has been a transformative year for open source, with rapid innovation and pivotal industry changes. This talk will delve into the major developments across the open source landscape, particularly within the open source database industry. We’ll explore key software releases, the growing role of cloud-native solutio...

more

09:15 - 10:00 Grand Ballroom Keynote
10:15
PGConf Organizers

Day 1 Morning Tea Break
Day 1 Morning Tea Break

presented by PGConf Organizers from PGConf India

Day 1 Morning Tea Break

10:15 - 10:45 Grand Ballroom Other
10:45
Kevin Biju

A lesser known Superpower of Postgres Logical Replication: Protocol Versions

presented by Kevin Biju from Clickhouse

Checkout the slides

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

more

10:45 - 11:30 Grand Ballroom 1 Database Administration
Rushabh Lathia Dilip Kumar

Navigating Challenging Customer Escalations in PostgreSQL: Strategies for Resolution and Prevention

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

more

10:45 - 11:45 Neptune Sponsor Hall
Vigneshwaran C

Understanding Write-Ahead Logging (WAL) in PostgreSQL

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

more

10:45 - 11:30 Jupiter Database Engine Developers
Anup Sharma Mehboob Alam

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

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

more

10:45 - 11:30 Grand Ballroom 2 Application Developer
11:30
Amit Langote

Hacking Postgres Executor For Performance

presented by Amit Langote from Microsoft

Checkout the slides

Checkout the slides

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

more

11:30 - 12:15 Grand Ballroom 1 Database Engine Developers
Shlok Kyal

How to Upgrade Replication Clusters without Downtime?

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

11:30 - 12:15 Grand Ballroom 2 Application Developer
Joe Conway

Collation Challenges: Sorting it Out

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

more

11:30 - 12:15 Jupiter Database Administration
12:15
Andrey Fleyta

Building reliable high performance infrastructure in big enterprises with Postgres
Building reliable high performance infrastructure in big enterprises with Postgres

presented by Andrey Fleyta from PostgresPro

Platinum Sponsor Keynote by PostgresPro:

Building reliable high performance infrastructure in big enterprises with Postgres

12:15 - 12:30 Grand Ballroom 1 Sponsor Keynote
PGConf Organizers

Diamond Sponsor Hall by Google Cloud
Diamond Sponsor Hall by Google Cloud

presented by PGConf Organizers from PGConf India

Diamond Sponsor Hall by Google Cloud

12:15 - 13:15 Neptune Sponsor Hall
Shalaka Dengale Ramya Bhat

Building Scalable APIs: PostgreSQL Meets GraphQL

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

more

12:15 - 13:00 Grand Ballroom 2 Application Developer
12:30
Balaji Venkat

Experimental approach towards Replication performance optimization in Postgres
Experimental approach towards Replication performance optimization in Postgres

presented by Balaji Venkat from IITM Pravartak

Checkout the slides

Platinum Sponsor Keynote by IITM Pravartak:

Experimental approach towards Replication performance optimization in Postgres

12:30 - 12:45 Grand Ballroom 1 Sponsor Keynote
13:00
PGConf Organizers

Day 1 Lunch
Day 1 Lunch

presented by PGConf Organizers from PGConf India

Day 1 Lunch

13:00 - 14:00 Grand Ballroom Other
14:00
Ashutosh Bapat

Graph databases, PostgreSQL and SQL/PGQ

presented by Ashutosh Bapat from Microsoft

Checkout the slides

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

more

14:00 - 14:45 Grand Ballroom 2 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

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

more

14:00 - 14:45 Jupiter Database Engine Developers
Sonia Valeja

pgBackRest: Elevating PostgreSQL Backup Game

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

more

14:00 - 14:45 Grand Ballroom 1 Database Administration
Shriram Muthukrishnan

Unleashing the Power of Azure Database for PostgreSQL Flexible Server
Unleashing the Power of Azure Database for PostgreSQL Flexible Server

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

14:00 - 15:00 Neptune Sponsor Hall
14:45
Shivji Kumar Jha

Pushing PostgreSQL to the Limits: Tackling Analytics Workloads with Extensions

presented by Shivji Kumar Jha from Nutanix

Checkout the slides

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

more

14:45 - 15:30 Jupiter Database Engine Developers
Harish Perumal

PostgreSQL : Page Buffer Overview
PostgreSQL : Page Buffer Overview

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

more

14:45 - 15:30 Grand Ballroom 1 Database Engine Developers
Hemendra Sharma

Postgres as a Message Broker to handle asynchronous task at scale

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

more

14:45 - 15:30 Grand Ballroom 2 Application Developer
15:30
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

Checkout the slides

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

more

15:30 - 16:15 Jupiter Database Administration
Jobin Augustine

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

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

more

15:30 - 16:15 Grand Ballroom 2 Application Developer
Pavan Deolasee

Beginner's guide to PostgreSQL Hacking

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

more

15:30 - 16:15 Grand Ballroom 1 Database Engine Developers
PGConf Organizers

Platinum Sponsor Hall by IITM Pravartak
Platinum Sponsor Hall by IITM Pravartak

presented by PGConf Organizers from PGConf India

Platinum Sponsor Hall by IITM Pravartak

15:30 - 16:15 Neptune Sponsor Hall
16:15
PGConf Organizers

Day 1 Evening Tea Break
Day 1 Evening Tea Break

presented by PGConf Organizers from PGConf India

Day 1 Evening Tea Break

16:15 - 16:45 Grand Ballroom Other
16:45
Sujit Kuruvilla

All the Postgres Things at Microsoft
All the Postgres Things at Microsoft

presented by Sujit Kuruvilla from Microsoft

Checkout the slides

Diamond Sponsor Keynote by Microsoft:

Microsoft is investing a lot in Postgres—including in the Postgres core, Citus open source, Patroni, PgBouncer, pgcopydb, pg_cron, & more Postgres extensions. And Microsoft offers two Azure managed services for PostgreSQL, one is regular and one is distributed Postgres built on C...

more

16:45 - 17:00 Grand Ballroom Sponsor Keynote
17:00
Sujatha Mandava

Observability and Manageability in Google Cloud Databases
Observability and Manageability in Google Cloud Databases

presented by Sujatha Mandava from Google

Checkout the slides

Diamond Sponsor Keynote by Google Cloud:

Sujatha Mandava, Director of GCP Databases, emphasizes Google Cloud Database's commitment to enhanced observability and manageability, showcasing tools like the Index Advisor for proactive performance optimization, the Database Center for a unified, streamlined view of complex...

more

17:00 - 17:15 Grand Ballroom Sponsor Keynote
17:15
PGConf Organizers

Postgres Women Event
Postgres Women Event

presented by PGConf Organizers from PGConf India

Postgres Women Event

17:15 - 17:30 Grand Ballroom Other
17:30
PGConf Organizers

Day 1 Lightning Talks
Day 1 Lightning Talks

presented by PGConf Organizers from PGConf India

Day 1 Lightning Talks

17:30 - 18:15 Grand Ballroom Other
19:00
PGConf Organizers

Conference Dinner on 6th March, 2025 at Byg Brewsky
Conference Dinner on 6th March, 2025 at Byg Brewsky

presented by PGConf Organizers from PGConf India

The conference dinner is organised on 6th March 2025, 7pm onwards at:

Byg Brewski Brewing Company

9, 36, 4th Floor, Vaishnavi Sapphire Centre, Tumkur Rd, Yeshwanthpur Industrial Area, Phase 1, Yeswanthpur, Bengaluru, Karnataka 560022

https://maps.app.goo.gl/bmMEfdsvtUfAa7L16

19:00 - 22:00 Grand Ballroom Other
2025-03-07
08:00
PGConf Organizers

Networking Over Breakfast
Networking Over Breakfast

presented by PGConf Organizers from PGConf India

Networking Over Light Snacks

08:00 - 09:00 Grand Ballroom Other
09:00
PGConf Organizers

Round Table Discussion
Round Table Discussion

presented by PGConf Organizers from PGConf India

A Round Table Discussion about PostgreSQL & the AI Revolution: Community, Innovation, and the Future

09:00 - 09:45 Grand Ballroom Other
09:45
Jim Mlodgenski

PostgreSQL at Amazon
PostgreSQL at Amazon

presented by Jim Mlodgenski from Amazon Web Services

PostgreSQL has a rich history at Amazon from wide spread usage across the company to a number AWS offerings. In this session, we will discuss how Amazon started its journey into PostgreSQL including the mass migration off of Oracle and the origins of Amazon RDS for PostgreSQL. We will then talk about how PostgreSQL is used today throughout Amazon and the current AWS offerings including Amazon A...

more

09:45 - 10:00 Grand Ballroom Sponsor Keynote
10:00
Tom Kincaid

EDB and Postgres through the years and in the years to come

presented by Tom Kincaid from EDB

EDB was founded over 20 years ago as a company making a strategic bet centered on the success of Postgres.This talk will go over key moments in the company's journey with Postgres over the past two decades.

The talk will present how the company and their over 1600 customers, which include some of the world's largest financial institutions, governments, Telecommunication providers and milit...

more

10:00 - 10:15 Grand Ballroom Sponsor Keynote
10:15
PGConf Organizers

Day 2 Morning Tea Break
Day 2 Morning Tea Break

presented by PGConf Organizers from PGConf India

Day 2 Morning Tea Break

10:15 - 10:45 Grand Ballroom Other
10:45
PGConf Organizers

Diamond Sponsor Hall by AWS
Diamond Sponsor Hall by AWS

presented by PGConf Organizers from PGConf India

Diamond Sponsor Hall by AWS

10:45 - 11:45 Neptune Sponsor Hall
Bruce Momjian

Securing PostgreSQL From External Attack

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

more

10:45 - 11:30 Grand Ballroom 1 Database Administration
Varun Dhawan

Using Postgres to locate the best coffee near you!

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

more

10:45 - 11:30 Grand Ballroom 2 Application Developer
Rakesh Raghav Puja Audhya

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

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

10:45 - 11:30 Jupiter Database Administration
11:30
Hannu Krosing

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

presented by Hannu Krosing from Google

Checkout the slides

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

more

11:30 - 12:15 Grand Ballroom 2 Application Developer
Nikhil Sontakke

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

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

11:30 - 12:15 Jupiter Database Engine Developers
Pat Wright

Speaking and Community Involvement for the Introvert

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

more

11:30 - 12:15 Grand Ballroom 1 Case Study
12:15
Kshetrapaldesi Tutika

Enhancing Security in PostgreSQL: Key Changes from Version 10 to 17

presented by Kshetrapaldesi Tutika from Microsoft

Checkout the slides

PostgreSQL has undergone significant security enhancements from version 10 to version 17, particularly in the areas of roles and permissions. This talk will provide an in-depth overview of these changes, focusing on the impact of the new security measures on database management and user access control. Key topics will ...

more

12:15 - 13:00 Jupiter Database Administration
Leonid Albreht

Reliability features in Postgres Pro: BiHA, load balancing and backups
Reliability features in Postgres Pro: BiHA, load balancing and backups

presented by Leonid Albreht from PostgresPro

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 fault-tolerant solutions. We will also review how the application works with a D...

more

12:15 - 13:00 Neptune Sponsor Hall
Amul Sul

Optimising Column Order for Better Performance and Maintainability

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

more

12:15 - 13:00 Grand Ballroom 1 Database Administration
Ants Aasma

Things your explain plan is not telling you

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

more

12:15 - 13:00 Grand Ballroom 2 Application Developer
13:00
PGConf Organizers

Day 2 Lunch
Day 2 Lunch

presented by PGConf Organizers from PGConf India

Day 2 Lunch

13:00 - 14:00 Grand Ballroom Other
14:00
Deepak Mahto

Accelerating PL/pgSQL Code Conversion on Migration from Another Database

presented by Deepak Mahto from DataCloudGaze Consulting

Checkout the slides

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

more

14:00 - 14:45 Grand Ballroom 2 Application Developer
Amit Thakur

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

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

more

14:00 - 14:45 Jupiter Application Developer
Yugank Srivastava

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

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

more

14:00 - 14:45 Grand Ballroom 1 Database Administration
14:45
Gaurav Kukreja

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

presented by Gaurav Kukreja from Yugabyte

Checkout the slides

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

more

14:45 - 15:30 Grand Ballroom 2 Application Developer
Claire Giordano

Beginner's Guide to Partitioning vs. Sharding in Postgres

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

more

14:45 - 15:30 Grand Ballroom 1 Database Administration
Pavlo Golub

When it all GOes right

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

more

14:45 - 15:30 Jupiter Application Developer
15:30
Nisha Moond

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

presented by Nisha Moond from Fujitsu

Checkout the slides

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

15:30 - 16:15 Grand Ballroom 1 Database Administration
Gunjan Juyal Eeshan Gupta

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

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

more

15:30 - 16:15 Grand Ballroom 2 Application Developer
Evgenii Ivanov

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

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

more

15:30 - 16:15 Jupiter Case Study
16:15
PGConf Organizers

Day 2 Evening Tea Break
Day 2 Evening Tea Break

presented by PGConf Organizers from PGConf India

Day 2 Evening Tea Break

16:15 - 16:45 Grand Ballroom Other
17:00
PGConf Organizers

Day 2 Lightning Talks And Closing Notes
Day 2 Lightning Talks And Closing Notes

presented by PGConf Organizers from PGConf India

Day 2 Lightning Talks Followed by Closing Notes

17:00 - 17:45 Grand Ballroom Other
Unscheduled events
Atsushi Torikoshi

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

presented by Atsushi Torikoshi from SRA OSS K.K.

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