Speakers

Keynotes

Bruce Momjian

Bruce Momjian

Vice President, Postgres Evangelist, EnterpriseDB
Co-founder, PostgreSQL Global Development Group

Bruce Momjian is co-founder and core team member of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He has been employed by EDB since 2006. He has spoken at many international open-source conferences and is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley.

Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world's largest law firms. As an academic, Bruce holds a Masters in Education, an honorary doctorate, was a high school computer science teacher, and lectures internationally.

Making Postgres Central in Your Data Center

Postgres has the unique ability to act as a powerful data aggregator in many data centers. This talk shows how Postgres's extensibility, access to foreign data sources, and ability handle NoSQL-like and data warehousing workloads gives it unmatched capabilities to function in this role.

Christopher Travers

Christopher Travers

PostgreSQL and Infrastructure Professional

Chris Travers has 25 years of experience with PostgreSQL in many roles from DBA to developer and is active on commitfiests. He also actively presents at conferences around the world. He is deeply committed to helping expand Postgres worldwide. He has been involved in leading other open source software projects through the years, including LedgerSMB which he helped found. He currently lives in Indonesia for family reasons and believes in helping ensure that the PostgreSQL community and we can come together across diverse cultural and other backgrounds in our community to build the economic commons that economically support so many of us.

The Future of Postgres in a Changing World

Open source software programs, including PostgreSQL, first arose to prominence in the 1990s. This was a product in part of geopolitical and economic changes of the time, particularly the role that globalization played in the development of open source software. Today the world is changing again and we are seeing an effort to disconnect economies. What does this mean for the future of open source software in general and PostgreSQL in particular?

Recently we have seen a lot of warning signs from the US including the failed RESTRICT Act, the purges of certain Russian Linux kernel maintainers, and more, and there are reasons to think that open source software may be in the crosshairs of some governments from a geopolitical perspective. What does this mean for the future of PostgreSQL? How should people evaluate open source projects in terms of geopolitical risks? And what can we do to help ensure the community is geopolitically resilient?

Oleg Bartunov

Oleg Bartunov

Co-founder and CEO of Postgres Professional

Oleg Bartunov is a professional astronomer turned leading PostgreSQL developer, with over 30 years of experience in the PostgreSQL community. He is a co-founder and CEO of Postgres Professional, a company dedicated to advancing PostgreSQL development and support. Oleg’s expertise lies in non-atomic data types (arrays, hstore, jsonb), full-text search, and advanced indexing techniques (GiST, GIN, SP-GiST, KNN). His first major contribution to PostgreSQL was implementing locale support, a breakthrough that opened the database to a global audience and paved the way for its internationalization. A passionate advocate for PostgreSQL, Oleg has been promoting the database globally, speaking at numerous conferences, and building a strong professional PostgreSQL community in Russia. Since 2009, he has also actively advocated for PostgreSQL in Nepal, including regular lectures at Kathmandu University. Outside databases, Oleg is an avid trail runner and mountaineer, having completed the Great Himalayan Trail (GHT).

PostgreSQL: The Perfect Database for Nepal – Building a Community for the Future

PostgreSQL, a mature and powerful open-source database, has a proven track record of success across industries and countries. With its rich ecosystem of tutorials, books, and a vibrant global community known for collaboration and mutual support, PostgreSQL is an ideal choice for Nepal’s technological growth.
This talk highlights why PostgreSQL’s open model and independence make it perfect for education, enabling universities to train developers and grow local expertise. We’ll also explore practical steps to build a thriving PostgreSQL community in Nepal, from organizing meetups to contributing to the global ecosystem.

Workshops

Abhinav Sagar

Abhinav Sagar

Bio is not yet published

Building Resilient PostgreSQL Systems: HA and Load Balancing Techniques

In this workshop we will be setting up a High Availability (HA) and load balancing environment for PostgreSQL which can be quite beneficial for ensuring your database remains operational and performs well, even under heavy load or during failures. Here are some options you can consider for your workshop: High Availability (HA) Options Streaming Replication: Synchronous Replication: Ensures no data loss by waiting for the standby server to confirm the transaction before committing. Asynchronous Replication: Faster but may result in some data loss if the primary server fails before the standby catches up. Logical Replication: Allows replication of specific tables or databases, providing more flexibility. Failover Solutions: Patroni: A popular tool for managing PostgreSQL HA, which automates failover and recovery. PgBouncer: Lightweight connection pooler that can help manage database connections efficiently. Load Balancing Options Pgpool-II: A middleware that provides connection pooling, load balancing, and replication management. Supports both read and write load balancing. HAProxy: A robust load balancer that can distribute read-only queries across multiple replicas. Citus: A PostgreSQL extension that transforms your database into a distributed system, enabling horizontal scaling and load balancing. Example Setup for Workshop Primary and Standby Servers: Configure streaming replication between primary and standby servers. Use synchronous replication for critical data to ensure no data loss. Load Balancer: Set up Pgpool-II or HAProxy to distribute read queries across multiple replicas. Ensure write queries are directed to the primary server. Monitoring and Failover: Implement Patroni for automated failover and recovery. Use monitoring tools like Prometheus and Grafana to keep track of your database health. Technical Requirements: Laptop with 8 GB RAM, 2 - 3 Linux VM's with 50 GB storage of each VM. Target Audience : Students, IT Professionals (Beginners, Intermediate, Advanced)

Egor Rogov

Egor Rogov

Postgres Professional

Egor Rogov is the author of the PostgreSQL Internals book (in english) and brings over 20 years of experience in database management systems as both an application developer and project manager. Since 2015, he has been actively contributing to educational programs at Postgres Professional, where he shares his expertise through training, workshops, and other initiatives.

Why can’t we continue a transaction after an error?

Subtitle: A journey into the subterranean world of subtransactions In this workshop we are going to cover rather wide range of features related under the hood to the subtransaction mechanics. Among them: snapshot isolation and multiversion concurrency control, transaction-level and statement-level rollback, rollback to savepoint, subtransactions vs autonomous transactions, PL/pgSQL exception handling and its overhead. The objective is to lay a foundation that allows us to reason about the root causes of seemingly unrelated outcomes. This workshop is intended for mid-level developers and DBAs who have some PostgreSQL experience and want to gain deeper knowledge of inner workings of the server. People with previous Oracle experience will further benefit from brief comparison of these two systems. --- 2 hours workshop. Together with Pavel Luzanov.

Swastik Gurung

Swastik Gurung

Open Source and PostgreSQL Enthusiast

I am a Data Operations Manager with comprehensive expertise in PostgreSQL administration, database architecture, and data integration technologies. With extensive experience across major PostgreSQL versions, I specialize in replication strategies, performance optimization, and high-availability configurations utilizing tools such as repmgr, pgbouncer, and Bucardo. My background also includes ERP systems, data modeling, and Linux-based infrastructure, allowing me to approach complex data challenges with practical, scalable solutions. I am deeply committed to leveraging open-source technologies to drive innovation and operational efficiency in data-driven environments.

Extensions in PostgreSQL, and how to develop one

Overview The workshop is intended to provide an overview of the PostgreSQL Extensions, along with a hands-on session on enabling users to develop a custom extension by themselves. Extensions on PostgreSQL are there to enhance the functionality of the Database System. It adds extra functionality to your database by modifying and enhancing the execution of certain processes. Most of the developers are unaware of the extensions in PostgreSQL, hence they build their own modules in programming languages instead of leveraging the benefit from built-in extensions. This adds upon extra time and effort onto the development phase, which affects the resource allocation of the whole project. With the help of this workshop, participants should be able to get themselves familiar with extensions in PostgreSQL and be able to build one for themselves. The workshop shall be conducted in two phases: 1. Introduction to PostgreSQL built-in extensions 2. Creating a custom extension The main intention of the first phase is to get participants familiar with some popular built-in extensions of postgres contrib, such as pgcrypto, plpgsql, pg_stat_statements, pg_trgm. This will help participants understand how an extension adds upon the functionality provided by the database system and sometimes eases up their work burden through readily available functions. On to the second phase, we’ll try hands-on exercise for developing a custom extension for PostgreSQL. This will include creating a control file for the extension in C, writing plpgsql functions to achieve an output and finally compiling the extension using gcc. Upon completion of the workshop, participants will have a clear understanding on the usages of PostgreSQL extensions and why one should develop it, if need be. Speaker’s Bio My name is Swastik Gurung, currently working as a Data Operations Manager at Bajra Technologies Pvt. Ltd., having 8 years of Experience with PostgreSQL and MySQL. I have previously participated in PgConf Nepal 2018 and 2023, while delivering a workshop during PgConf 2018 titled “Acquiring government compliance for computerized billing using PostgreSQL”. Target Audience This session is intended for PostgreSQL Enthusiasts, Database Administrator and Developers. Technical Requirements Below are the list of technical requirements for the session: - Prior Knowledge of SQL and PostgreSQL, PostgreSQL (latest) setup in a local or dockerized environment. - Client tool for PostgreSQL (psql, PgAdmin, DBeaver) - Linux Operating System (preferably) - Some experience on Linux/Bash command - Internet connection on the PC - C compiler should be installed on a local machine, for building the extension file.

Talks

Christopher Travers

Christopher Travers

PostgreSQL and Infrastructure Professional

Chris Travers has 25 years of experience with PostgreSQL in many roles from DBA to developer and is active on commitfiests. He also actively presents at conferences around the world. He is deeply committed to helping expand Postgres worldwide. He has been involved in leading other open source software projects through the years, including LedgerSMB which he helped found. He currently lives in Indonesia for family reasons and believes in helping ensure that the PostgreSQL community and we can come together across diverse cultural and other backgrounds in our community to build the economic commons that economically support so many of us.

A Guided Tour of PostgreSQL Architecture and Source

Ever want to learn to code PostgreSQL extensions or even make contributions? Or just want to become a better DBA? In both cases having access to the source and being able to read it can really help. This talk is a brief guide to the PostgreSQL architecture and corresponding source code layout. If you are developing extensions this gives you access to all the functionality PostgreSQL already offers, and if you are a database administrator, having access to the code allows you to understand behavior which would otherwise counterintuitive.

Dev Raj Gautam

Dev Raj Gautam

https://www.adinovi.com/

Dev Raj Gautam is a seasoned Project/Product Manager, Software Engineer, and Researcher with over 14 years of diverse experience spanning software engineering, cybersecurity, AI governance, and digital transformation. With dual degrees in MSCIT Technology and an MBA, Dev brings a rare blend of technical depth and business acumen—helping organizations innovate with confidence while maintaining compliance and operational excellence. Throughout his career, Dev has led transformative projects for government agencies, international development partners (such as USAID and the World Bank), high-growth startups, and Fortune 500 companies. His work includes national-scale digital initiatives in Nepal, secure AI-driven platforms for SMBs, healthtech solutions in Australia, and ERP integrations for U.S.-based enterprises. Currently, Dev is a Partner – Digital Transformation and Cybersecurity at Adinovi, where he helps clients adopt emerging technologies, implement ISO-compliant security frameworks, and align IT strategy with business priorities. His approach focuses on integrating people, process, and platforms to unlock long-term value. As a certified auditor for ISO/IEC 27001, 27701, and 42001, he plays a critical role in helping companies navigate complex regulatory landscapes while future-proofing their operations. Dev is also a frequent speaker at conferences and meetups, advocating for secure and ethical tech adoption. A former software engineer turned strategic consultant, Dev remains deeply involved in building and evaluating technologies that improve human lives—especially in areas like digital finance, financial inclusion, safe internet practices, and decentralized identity systems. Explore more about his work and insights at devgautam.com.np.

Protecting PII and AI Workloads in PostgreSQL

PostgreSQL is a go-to database for handling data which obviously would include personally identifiable information (PII), financial records, and AI/ML data workloads, yet many organizations rely solely on application-level access, leaving databases vulnerable. This session explores how PostgreSQL-native security features when like Row-Level Security (RLS), Column Security, and pgAudit can protect sensitive data at the source. With AI adoption rising, data in PostgreSQL will be increasingly used for model training , introducing new security and privacy challenges. We’ll discuss how to prevent PII leaks in AI workloads, enforce access control on ML datasets, and ensure compliance in AI-driven applications. Through live demos, attendees will learn how to implement such measures to protect PII and AI Workloads in PostgreSQL. This session is suitable for DBAs, Developers, Security Engineers, and AI practitioners looking to fortify PostgreSQL against modern threats while maintaining scalability, performance, and compliance.

Ekaterina Sokolova

Ekaterina Sokolova

Postgres Professional

Bio is not yet published

PostgreSQL Tools for Hunting Down and Fixing Non-Optimal Queries

Performance is a key quality of DBMS operation. But sometimes an attempt at optimization looks like detective work: it is necessary to identify queries for improvement and then transform them. In this report, we will learn what tools PostgreSQL has to find potential candidates for improvement: slow, blocking, unnecessary or error-containing queries. Why and how to read the EXPLAIN and EXPLAIN ANALYZE results, why the optimizer does not always choose the best execution method and how to fix this with proper configuration. We will consider open source extensions for researching and configuring queries. Based on the results of the report, we will compile a consistent list of possible actions for query optimization.

Ivan Panchenko

Ivan Panchenko

Bio is not yet published

PL/* programming

We compare the capabilities and performance of different programming languages for stored procedure in PostgresSQL

Pavel Luzanov

Pavel Luzanov

Bio is not yet published

What's new in PostgreSQL 18

PostgreSQL 18 will be released in the fall. However, as of April 8, changes to this version are no longer accepted. Therefore, we can now consider which features will be included in the upcoming release.

Premnath J

Premnath J

Bio is not yet published

Addressing Scalability Challenges in PostgreSQL Sharding: Key Issues and Solutions

In the era of big data, the ability to scale databases efficiently is crucial for maintaining performance and reliability. PostgreSQL, a powerful open-source relational database management system, offers a variety of solutions to address scalability challenges. PostgreSQL sharding is an advanced method for achieving horizontal scalability by partitioning data across multiple servers. However, its implementation presents several technical challenges that must be addressed to ensure optimal performance and reliability. This abstract identifies key issues in PostgreSQL sharding, including: Uneven data distribution: Ensuring data is evenly distributed across shards to prevent hotspots and ensure balanced load. Performance degradation of cross-shard queries: Mitigating the latency and complexity associated with queries that span multiple shards. Data consistency in distributed transactions: Maintaining ACID properties across distributed transactions to ensure data integrity. Balanced data growth: Managing the even growth of data across shards to avoid imbalances. Shard health monitoring: Continuously monitoring the health and performance of each shard to detect and address issues promptly. This abstract also proposes solutions to these challenges, such as implementing effective sharding strategies, optimizing query performance, and employing robust monitoring tools.

Rupak Raj Ghimire

Rupak Raj Ghimire

Bio is not yet published

SQL Sorcery: Writing Less Code with More PostgreSQL

Idea: Developers often underestimate how powerful PostgreSQL is—not just as a database, but as a tool to dramatically simplify application logic. This talk dives into a collection of built-in PostgreSQL functions and features that let you write smarter, cleaner, and fewer lines of SQL which we usually solve using back-end program. Contents: We will explore the use case of : coalece, greatest, *_agg, distinct, *_series, PL/pgSQL functions, triggers, making dashboard-ready stats with conditional aggregates and window functions etc. Delivery Mode: Talk, Quick Demo Audience: Developers who use PostgreSQL in production but rely heavily on app-side logic.

Semab Tariq

Semab Tariq

Bio is not yet published

Boost Postgres Performance & Reduce Operational Costs

Many customers encounter performance issues with their PostgreSQL databases, and their first instinct is often to upgrade hardware. However, this isn’t always the best solution. In this talk, I'll cover key strategies to fine-tune PostgreSQL performance, improve query efficiency, and reduce cloud expenses. Through practical examples, we'll explore actionable techniques to get the most out of our PostgreSQL database. Audience will learn: - What performance really means – Going beyond faster hardware. - Cost-saving strategies – Reduce cloud expenses through better indexing, query optimization, and configurations. - PostgreSQL power-ups – Leveraging JIT (Just-In-Time Compilation), and partitioning - Decoding EXPLAIN ANALYZE – Understanding query plans to identify inefficiencies. - Essential tuning parameters – Adjusting PostgreSQL settings for immediate performance gains. - Query restructuring – When and how to rewrite queries for maximum efficiency. Who Should Attend? This session is ideal for developers, DBAs, and tech leads looking to enhance PostgreSQL performance, optimize cloud costs, and improve overall database efficiency.

Yogesh Jain

Yogesh Jain

EnterpiseDB

I am a passionately curious full-stack developer, working as a Staff SDE at EnterpiseDB. I specialize in building scalable solutions using open-source technologies. My expertise spans Kubernetes, observability, distributed systems, and cloud-native PostgreSQL, with a strong focus on solving real-world challenges through practical, scalable engineering.

Unified Observability: Monitoring Postgres Anywhere with OpenTelemetry

PostgreSQL is widely used across cloud, Kubernetes, and bare metal environments. But how can we monitor it efficiently across all these setups without vendor lock-in or high costs? In this talk, we'll explore how OpenTelemetry helps achieve consistent and scalable observability for Postgres - no matter where it runs. We'll walk through how to collect metrics and logs, integrate them with open-source observability tools, and optimize monitoring for both performance and cost. Expect live demos and practical insights on making PostgreSQL monitoring simple, efficient, and future-ready with OpenTelemetry. Key Takeaways: - How OpenTelemetry brings consistent Postgres observability across cloud, kubernetes, and bare metal - How to collect telemetry data (metrics and logs) for effective Postgres monitoring - How to use open-source tools (Prometheus, Loki, Grafana) to observe Postgres - Tips to reduce observability costs while keeping full visibility - Live demo of Postgres monitoring in cloud-native environments