PG Down Under 2026 Program

presented by Caleb Schoepp

When you run jobs on behalf of thousands of tenants it’s only a matter of time before one noisy neighbor floods the system, starves everyone else, and brings your queue to its knees. This talk is about building a bulletproof multi-tenant job queue using tools you already have.

We'll start with the database. Postgres is a perfectly good job queue if you know the tricks: SELECT ... FOR UPDATE ...

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 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 Venkata Ravi Kumar Yenugula and Rajni Baliyan

This session presents an end-to-end blueprint for migrating from Oracle to PostgreSQL using Ora2Pg, the free Perl-based migration toolkit. Beginning with the business case for migration, we examine how Ora2Pg automates schema export, data movement via the COPY protocol, PL/SQL-to-PL/pgSQL translation, and assessment reporting that grades migration complexity from A to D. Attendees will walk thr...

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

For decades, the query optimizer's hardest problem has not been searching for a plan - it has been predicting how many rows each operator will produce. Cardinality estimation errors, and underestimation especially, compound multiplicatively across joins: estimate one row against a reality of a million, and the optimizer commits to a nested-loop plan that runs orders of magnitude too slow. This ...

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

Ever since PostgreSQL gained parallel query in 9.6, it has unconditionally refused to parallelise any part of a plan that touches a temporary table. The reason is structural: temporary-table pages live in the leader's local buffers, which parallel workers cannot see, so the planner simply marks such scans parallel-restricted.

As parallel execution has matured — partial aggregation, parallel ...

presented by Avinash Vallarapu

There is a category of PostgreSQL performance work that costs nothing but attention - features already in the database, already free, that most clusters never switch on or never tune. This is not about buying a bigger instance or re-architecting anything. It is about the parameters you usually miss to tune, index-only scan you are missing because your index does not cover the query, the extende...

presented by Peter Smith and Ajin Cherian

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

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

Peter Smith opens with the new publication syntax. Post...