Program for PGConf India, 2025

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

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
- Setting Up Logical Replication
- Prerequisites and environment setup
- Configuring publisher and subscriber
- Step-by-step guide o...

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

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
Training Day Lunch
Training Day Lunch
presented by PGConf Organizers from PGConf India
Training Day Lunch
13:00 - 14:00 Grand Ballroom 1 Other
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.
- PL/pgSQL Foundations
- What is Dollar Quoting and How PL/pgSQL Co...


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

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
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
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
Opening Remarks
Opening Remarks
presented by PGConf Organizers from PGConf India
Opening Remarks
09:00 - 09:15 Grand Ballroom Other
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
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
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

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

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

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

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
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
Day 1 Lunch
Day 1 Lunch
presented by PGConf Organizers from PGConf India
Day 1 Lunch
13:00 - 14:00 Grand Ballroom Other
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

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

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
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
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
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
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
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
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
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
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
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
Postgres Women Event
Postgres Women Event
presented by PGConf Organizers from PGConf India
Postgres Women Event
17:15 - 17:30 Grand Ballroom Other
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
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
Networking Over Breakfast
Networking Over Breakfast
presented by PGConf Organizers from PGConf India
Networking Over Light Snacks
08:00 - 09:00 Grand Ballroom Other
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
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
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
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
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
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
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

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

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

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
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
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
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
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
Day 2 Lunch
Day 2 Lunch
presented by PGConf Organizers from PGConf India
Day 2 Lunch
13:00 - 14:00 Grand Ballroom Other
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
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
“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
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
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
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
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...


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