Franck Pachot

Get a guided tour of new PostgreSQL features, extensions, and developer tools built in collaboration by Microsoft engineers and contributors. In this session, you’ll see live demonstrations and technical walk-throughs.

Cloud-native databases often use open-source embedded key-value stores on each node or shard. OLTP workloads are read- and write-intensive, typically relying on indexes for data access.

2025 is the year of AI agents, and we don’t want you to miss out! In this workshop, you will learn the core concepts of AI agents, such as reasoning, tools, and memory.

Data modeling has progressed beyond traditional SQL Normal Forms and the unstructured storage of early NoSQL systems. Modern applications demand flexible data models that merge normalized entities with semi-structured documents.

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.

This session will focus on the open-source distributed SQL databases TiDB and YugabyteDB. We will explore their building blocks to understand how they function, highlighting their similarities and architectural differences.

YugabyteDB distinguishes itself among distributed SQL databases by utilizing PostgreSQL's C code rather than building a compatibility layer from the ground up. This session will explore both the advantages and challenges of this architecture.

I use pg_hint_plan to learn about the optimizer, to understand the query planner choices, and, sometimes workaround a problem in production. But hinting is not easy.

As a developer, it is crucial to understand Isolation Levels and Multi-Version Concurrency Control (MVCC) to create scalable applications without compromising data integrity due to race conditions. Although the default isolation level in most databases is usually adequate, it is important to know and use it correctly in your application.

In this training, you will learn the limitations of monolithic PostgreSQL for High Availability and get insights on the future of databases in a cloud-native environment with sharding, distribution, and replication.

Come see a demo of YugabyteDB in a cloud-native lab environment. We will show how we can deploy, scale, and be resilient when running a YugabyteDB on containers. With an easy to reproduce docker-compose or K8s helm chart, we will discuss the advantages of a distributed database, showing the application continuity during planned or unplanned operations on the pods.

Coming to PostgreSQL after years of Oracle performance tuning, I realize that I approach PostgreSQL with tools and methods that are different from what a 'native' postgres DBA will start with.

Coming to PostgreSQL after years of Oracle performance tuning, I realize that I approach PostgreSQL with tools and methods that are different from what a 'native' postgres DBA will start with. What made my job easier on Oracle is also available, and free, for PostgreSQL: All those tools with why/how/when explanations and live demo.