PG Down Under 2026 Program

presented by PGDU Committee

presented by Joe Conway

I have been participating and contributing to the PostgreSQL community for over 26 years, and been interested in data and databases much longer than that. The journey from starting University to the present day has been filled with twists and turns that I never could have guessed. I will walk you through that journey and the lessons learned along the way in hopes that it will illustrate that li...

presented by Peter Smith and Ajin Cherian

This talk will be co-presented by Ajin Cherian and Peter Smith.

PostgreSQL 19 brings significant enhancements to logical replication, giving administrators far greater control over what gets replicated and how. In this talk, two PostgreSQL contributors who worked directly on these features cover the same new functionality from two complementary angles.

Ajin Cherian opens with the sequence...

presented by James Sadler

Almost every tool that touches SQL but isn't Postgres — linters, migration tools, query rewriters, proxies, ORMs, observability pipelines — has to understand the language without a running backend. And almost all of them get Postgres's dialect subtly wrong, because Postgres has one of the most intricate grammars in production software: a multi-thousand-line Bison grammar fused to a lexer that...

presented by PGDU Committee

presented by Ravi Kiran Venkata Bhaskarabhatta

PostgreSQL has cemented itself as the database of the AI era. With 55.6% developer adoption, major AI platforms scaling to hundreds of millions of users on PostgreSQL, and recent conference keynotes framing PostgreSQL as the foundation for agentic AI workloads, the conversation has shifted from whether PostgreSQL can handle AI-scale demands to how AI can transform the way we manage PostgreSQL i...

presented by Manan Gupta

A connection pooler is a lie you tell your application. The client thinks it has a PostgreSQL backend all to itself; in reality it is being multiplexed onto a shared pool. Every Postgres behaviour that quietly depends on which backend you are on is a chance for that lie to leak: GUCs, prepared statements, temp tables, advisory locks, LISTEN/NOTIFY, query cancellation, COPY, and the exte...

presented by Sameer Kumar and Roneel Kumar

PostgreSQL has matured into one of the most trusted databases for mission-critical workloads, but scaling it to tens or even hundreds of terabytes is a different game altogether. At this scale, the challenges shift from simple tuning to deep architectural decisions: vacuum pressure, index bloat, replication lag, and the limits of storage and I/O subsystems all start to matter.

In this talk...

presented by Evgeny Voropaev

The Delta Frame of Reference algorithm (DFOR) is a widely used solution for the lossless compression of integer sequences. DFOR, which is classified as differential compression method, provides a high compression ratio even for short data sequences, where statistical and dictionary-based compression methods can be ineffective. While nowadays the plenty of DFOR implementations are available...

presented by PGDU Committee

presented by Nishchay Kothari

PostgreSQL 19 is shaping up to be an important release for database operations teams. Rather than focusing only on new SQL capabilities, this release introduces several improvements aimed at reducing maintenance pressure, simplifying replication-related operations, and improving visibility into production systems.

In this session, I will take you on a practical tour of the PostgreSQL 19 feat...

presented by James Blackwood-Sewell

I’ve been working with Postgres since 2010, and over the years there have been many times when I’ve hit functionality or performance barriers and wanted to extend PostgreSQL to do new things.

This presented a problem for me: I knew I needed to use C, but as someone who didn’t have years of professional experience writing code for production this felt error-prone and daunting.

Enter PGRX, ...

presented by Craig Ringer

This talk presents otel_api, a generic OpenTelemetry distributed tracing and metrics API usable by all extensions. It explains why this API is needed - and how extension and application authors can benefit from it. I demonstrate working examples of useful tracing - including synchronous replication timing and tracing through foreign data wrapper (FDW) calls. Because the API is available as ...

presented by Eugene Bobkov

*The Challenge *

High availability in PostgreSQL environments is often assumed to be solved by managed cloud services. In practice, many default implementations rely on DNS-based failover mechanisms that can take up to five minutes to reroute application traffic. They do not guarantee zero data loss across regions, and they offer limited control over leader election and replication behavio...

presented by PGDU Committee

presented by Toby Hede

Encrypt Query Language (EQL) brings searchable encryption to PostgreSQL as ordinary column types. Encrypted values stay encrypted in the database, yet still support equality, ordering, and range queries backed by real indexes — with no decryption. This talk shows how encrypted types, index terms, and functional indexes fit together, and how a single source of truth keeps their query behaviour c...

presented by Shadab Mohammad

Agentic AI applications need more than an LLM, they need reliable data, memory, security, and guardrails. In this session Shadab will show how PostgreSQL pgvector, full-text search, JSONB, row-level security, constraints, transactions, and MCP provides the scaffolding for an autonomous agent.

He will explore how PostgreSQL retrieves trusted facts, records every step, and safely controls busi...

presented by Rajni Baliyan

Let’s be honest: nobody actually likes a midnight maintenance window. Taking an application offline to reclaim disk space, holding your breath during a sequence cutover on a logical migration, or dealing with flaky schema parsing scripts introduces massive operational stress. For years, the community has relied on complex external workarounds or third-party extensions to bypass these core limi...

presented by Diksha Sharma

Monitoring tools are effective at detecting when a server or PostgreSQL service is unhealthy, but they do not always explain why an incident occurred. Engineers may still need to search through large log files, compare timestamps, and connect related events across multiple sources before the cause becomes clear.

This session explores how PostgreSQL can be used as an investigation platform fo...

presented by PGDU Committee

presented by PGDU Committee

presented by PGDU Committee

presented by PGDU Committee