Program for PGConf India, 2025
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...
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 StudySecuring 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 AdministrationAccelerating 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 DeveloperPostgreSQL 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 AdministrationAccelerating 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
- Subtle art of code conversion, conversion is art not...
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 Studycbo_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 DeveloperBuilding 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 DeveloperUsing 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 DeveloperCollation 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 AdministrationPostgreSQL 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 AdministrationUnderstanding 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 DevelopersModern 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 DeveloperHow 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 ...
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 AdministrationBeing 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 ...
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...
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 DeveloperPostgreSQL 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 DevelopersPostgres 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 DeveloperBeginner'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 DevelopersHacking 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 DevelopersWhen 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 DeveloperpgBackRest: 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 AdministrationPushing 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 DevelopersThings 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 DeveloperA 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 AdministrationBeginner'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 AdministrationExtending 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 DeveloperPerformance 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 DeveloperScaling 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“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 AdministrationHarnessing 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 DeveloperPostgreSQL 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 TrainingQuery 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 TrainingGetting 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 TrainingPostgreSQL 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...
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 & 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 TrainingPgvector - 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 TrainingIntroduction 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.
TrainingA 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