Seattle 2024 Program

Unscheduled events
Zak Tedder Journey Through Postgres
Exploring the Elephant

presented by Zak Tedder

Okay, let’s talk about the elephant in the room: Postgres! PostgreSQL has a lot going on, and traversing the ups and downs of this database management system can be daunting. We’ll navigate through indexes, partake in partitions, synchronize with sequences, extend on extensions, and more!

Join us on a journey through Postgres! We’ll take a high-level exploration of the PostgreSQL database m...

more

Essentials
Grant McAlister Practical Memory Tuning for PostgreSQL

presented by Grant McAlister

This talk will first introduce the different ways PostgreSQL can use memory, from the operating system, to cluster wide and then into per session and per operation. From there we will dive into specifics around different PostgreSQL parameters like shared_buffers, work_mem, maintenance_work_mem and how to set them depending on your workload. The presentation will also cover some of the lesser kn...

more

Essentials
Jonah Harris Surpassing 100K Postgres Connections With An In-Database Connection Pooling Extension
Efficiently Scaling Postgres with Simplified Connection Management

presented by Jonah Harris

Managing high volumes of connections in PostgreSQL is critical for optimal performance and scalability. Traditionally, PgBouncer has been the go-to external connection pooler, offering lightweight and efficient connection management. In this talk, we introduce a version of PgBouncer that extends its functionality, allowing it to run either standalone or directly within PostgreSQL as an in-datab...

more

Ops
Thuymy Tran PostgreSQL for Oracle DBAs

presented by Thuymy Tran

Learn the architectural concepts, similarities/differences between the PostgreSQL engine and Oracle Database. Review Multi-version concurrency control (MVCC) and Subtransactions.

Essentials
Shree Vidhya Sampath Leveraging Patroni's synchronous replication feature to achieve high availability while running PostgreSQL on Kubernetes.

presented by Shree Vidhya Sampath

Ensuring high availability is crucial for databases to achieve resiliency and durability. However enabling high availability while running PostgreSQL on Kubernetes poses unique challenges navigating complexities such as increased write latency, node failures, leader elections, handling replication lag etc. This talk will focus on

  • Architectural components of how at Datadog we run PostgreSQL...
more

Ops
PostgresConf Organizers Keynotes

presented by PostgresConf Organizers

"Microsoft Keynote Room Level 5 - Ballroom 1"

PostgresConf Organizers Keynotes

presented by PostgresConf Organizers

PASS Data Community Summit Keynotes

PostgresConf Organizers Community Zone

presented by PostgresConf Organizers

Level 3 - Garden Lounge

PostgresConf Organizers Registration

presented by PostgresConf Organizers

Registration

PostgresConf Organizers Welcome Reception

presented by PostgresConf Organizers

Level 2 - Flex AB

PostgresConf Organizers Registration

presented by PostgresConf Organizers

Registration

PostgresConf Organizers Exhibit Hall

presented by PostgresConf Organizers

"Exhibit Hall Level 2 - Flex AB"

PostgresConf Organizers Lunch

presented by PostgresConf Organizers

"AWS Dining Hall Level 2 - Flex C"

PostgresConf Organizers Exhibit Hall

presented by PostgresConf Organizers

"Exhibit Hall Level 2 - Flex AB"

PostgresConf Organizers Community Zone

presented by PostgresConf Organizers

Level 3 - Garden Lounge

PostgresConf Organizers Lunch

presented by PostgresConf Organizers

"AWS Dining Hall Level 2 - Flex C"

Eric Lendvai Converting your schema from Oracle, MSSQL, MySQL to PostgreSQL in minutes with DataWharf

presented by Eric Lendvai

DataWharf is a free and open-source data modeling tool designed to facilitate the seamless migration of database schemas from Oracle, MSSQL, and MySQL to PostgreSQL in just minutes.

With DataWharf, you can easily map your column types, manage foreign key constraints, and validate your schema against various integrity rules. You can then generate migration scripts for empty catalogs or extend...

more

Dev
Grant Zhou Introducing SynchDB: Open-Source Synchronization Across Heterogeneous Databases with PostgreSQL
Seamless Integration for Modern Database Ecosystems and Bridging Data Silos

presented by Grant Zhou

As organizations increasingly manage diverse data ecosystems, ensuring seamless synchronization across heterogeneous databases is more important than ever.

We are excited to announce the open-source release of SynchDB at this conference. SynchDB is a powerful PostgreSQL extension designed to simplify data synchronization from heterogeneous databases such as MySQL, Oracle, and...

more

Ops