Schedule

This schedule is also available for mobile users and an iCalendar format is also available.
You can find the full conference information at the conference website. This schedule is subject to changes and will be updated when any changes occur.

Wednesday, September 05

Mission

09:00 - 12:00
PostgreSQL Administration Training
 Keith Fiske
12:30 - 13:30 - Lunch (Market Street)
13:30 - 16:30
Architecting real-time analytics for your customers
 Marco Slot

Stockton

09:00 - 12:00
Hands on with Azure Database for PostgreSQL ​
 Byju Sukumaran, Diana Putnam, Teja Mupparti
12:30 - 13:30 - Lunch (Market Street)
13:30 - 16:30
The World of PostGIS
 Leo Hsu and Regina Obe, Regina Obe and Leo Hsu

Lombard

09:00 - 12:00
PostgreSQL Application Development With Node.js
 Sehrope Sarkuni
12:30 - 13:30 - Lunch (Market Street)
13:30 - 16:30
Let's Build a Complex, Real-Time Data Management Application...before the session ends!
 Jonathan S. Katz

Thursday, September 06

Cyril Magnin

07:30 - 08:30 - Breakfast
08:30 - 08:40 - Welcome Craig Kerstiens, Stephen Frost
08:40 - 09:00 - Keynote - Update on Microsoft’s learning and progress on supporting PostgreSQL as a fully managed service on Azure (Cyril Magnin)
09:00 - 09:20 - Keynote from Ozgun Erdogan and Marco Slot (Citus Data) (Cyril Magnin) Marco Slot, Ozgun Erdogan
09:20 - 09:50 - Keynote - 5 Years of etcd: past, present, and future by Brandon Philips (Cyril Magnin)
10:00 - 10:20 - Coffee Break
10:30 - 11:20
A look at the Elephants trunk - PostgreSQL 11
 Magnus Hagander
11:30 - 12:20
Parallelism in PostgreSQL 11
 Thomas Munro
12:30 - 13:30 - Lunch (Embarcadero)
13:30 - 14:20
HOT - Understanding this important Update optimization
 Grant McAlister
14:30 - 15:20
How to deploy PostgreSQL using Kubernetes
 Peter Tormey
15:30 - 15:50 - Coffee Break
16:00 - 16:50
How to Monitor Your Database
 Baron Schwartz
17:00 - 18:00 - Lightning Talks
18:00 - 20:00 - Welcome Reception

Market Street

07:30 - 08:30 - Breakfast
08:30 - 08:40 - Welcome Craig Kerstiens, Stephen Frost
08:40 - 09:00 - Keynote - Update on Microsoft’s learning and progress on supporting PostgreSQL as a fully managed service on Azure (Cyril Magnin)
09:00 - 09:20 - Keynote from Ozgun Erdogan and Marco Slot (Citus Data) (Cyril Magnin) Marco Slot, Ozgun Erdogan
09:20 - 09:50 - Keynote - 5 Years of etcd: past, present, and future by Brandon Philips (Cyril Magnin)
10:00 - 10:20 - Coffee Break
10:30 - 11:20
The Evolution of Postgres High Availability
 Shaun Thomas
11:30 - 12:20
Dude, where's my byte?
 Srivathsava Rangarajan
12:30 - 13:30 - Lunch (Embarcadero)
13:30 - 14:20
A scalable, versioned document store in PostgreSQL
 Art Gillespie
14:30 - 15:20
Bloat in PostgreSQL: A taxonomy
 Peter Geoghegan
15:30 - 15:50 - Coffee Break
16:00 - 16:50
Debugging the Postgres Planner
 Melanie Plageman
17:00 - 18:00 - Lightning Talks
18:00 - 20:00 - Welcome Reception

Mission

07:30 - 08:30 - Breakfast
08:30 - 08:40 - Welcome Craig Kerstiens, Stephen Frost
08:40 - 09:00 - Keynote - Update on Microsoft’s learning and progress on supporting PostgreSQL as a fully managed service on Azure (Cyril Magnin)
09:00 - 09:20 - Keynote from Ozgun Erdogan and Marco Slot (Citus Data) (Cyril Magnin) Marco Slot, Ozgun Erdogan
09:20 - 09:50 - Keynote - 5 Years of etcd: past, present, and future by Brandon Philips (Cyril Magnin)
10:00 - 10:20 - Coffee Break
10:30 - 11:20
With a smart enough proxy, you can do anything
 Brian Cloutier
11:30 - 12:20
Five data models for sharding and which is right
 Craig Kerstiens
12:30 - 13:30 - Lunch (Embarcadero)
13:30 - 14:20
A New Hope for Database Migrations
 Scott Milliken
14:30 - 15:20
Connection Pooling 101
 Samantha Billington
15:30 - 15:50 - Coffee Break
16:00 - 16:50
PostgreSQL Stored Procedures
 Mark Wong
17:00 - 18:00 - Lightning Talks
18:00 - 20:00 - Welcome Reception

Stockton

07:30 - 08:30 - Breakfast
08:30 - 08:40 - Welcome Craig Kerstiens, Stephen Frost
08:40 - 09:00 - Keynote - Update on Microsoft’s learning and progress on supporting PostgreSQL as a fully managed service on Azure (Cyril Magnin)
09:00 - 09:20 - Keynote from Ozgun Erdogan and Marco Slot (Citus Data) (Cyril Magnin) Marco Slot, Ozgun Erdogan
09:20 - 09:50 - Keynote - 5 Years of etcd: past, present, and future by Brandon Philips (Cyril Magnin)
10:00 - 10:20 - Coffee Break
10:30 - 11:20
A Beginner's Tale of Migrating Column Types in PostgreSQL
 Belinda Adam
11:30 - 12:20
Add Redis to Postgres to Make Your Microservice Go Boom!
 Dave Nielsen
12:30 - 13:30 - Lunch (Embarcadero)
13:30 - 14:20
Connecting Galaxies
 Alyssa Ritchie, Boris Novikov, Henrietta Dombrovskaya
14:30 - 15:20
10 ways to load data into Postgres
 Leo Hsu and Regina Obe
15:30 - 15:50 - Coffee Break
16:00 - 16:50
TimescaleDB: Re-engineering PostgreSQL as a time-series database
 David Kohn
17:00 - 18:00 - Lightning Talks
18:00 - 20:00 - Welcome Reception

Friday, September 07

Cyril Magnin

08:00 - 09:00 - Breakfast
09:00 - 09:50
Hypothetical Partitioning for PostgreSQL
 Yuzuko Hosoya
10:00 - 10:20 - Coffee Break
10:30 - 11:20
Using JSON in PostgreSQL
 Andrew Dunstan
11:30 - 12:20
Just in time compilation in PostgreSQL
 Andres Freund
12:30 - 13:30 - Lunch (Embarcadero)
13:30 - 14:20
PostgreSQL Locking Issues: a talk for devs and DBAs
 Quinn Weaver
14:30 - 15:20
Your Herd of Elephants: PostgreSQL Replication
 Christophe Pettus
15:30 - 15:50 - Coffee Break
16:00 - 16:50
Computational Complexity and the Query Planner: Applying (Not So) Dusty Academics to Everyday Query Writing
 James Coleman
17:00 - 17:30 - Closing Session

Market Street

08:00 - 09:00 - Breakfast
09:00 - 09:50
Crashing Postgres for Fun and Laughs
 Brian Faherty
10:00 - 10:20 - Coffee Break
10:30 - 11:20
Lessons from building VeniceDB
 Min Wei
11:30 - 12:20
Building a real time analytics API at scale
 Sylvain Friquet
12:30 - 13:30 - Lunch (Embarcadero)
13:30 - 14:20
How PostgreSQL Extension APIs are Changing the Face of Relational Databases
 Ozgun Erdogan
14:30 - 15:20
ANSI, Schmansi!
 Sehrope Sarkuni
15:30 - 15:50 - Coffee Break
16:00 - 16:50
WAL: Everything you want to know
 Devrim Gündüz
17:00 - 17:30 - Closing Session

Mission

08:00 - 09:00 - Breakfast
09:00 - 09:50
Hello Greenplum
 Bradford D. Boyle
10:00 - 10:20 - Coffee Break
10:30 - 11:20
How to write Spatial SQL: Put some "where" in your WHERE clause
 Paul Ramsey
11:30 - 12:20
ZomboDB: Making Postgres & Elasticsearch Work Together Like it's 2018
 Emmett Plant, Eric B. Ridge
12:30 - 13:30 - Lunch (Embarcadero)
13:30 - 14:20
Hacking with PostgreSQL for fun and not so much profit
 Piotr Jarmuż
14:30 - 15:20
Cleaning out crocodiles teeth with PostgreSQL indexes - a story on all the index types in PG
 Louise Grandjonc
15:30 - 15:50 - Coffee Break
16:00 - 16:50
Don't Panic: Use the PostgreSQL Operator for Kubernetes and OpenShift
 Sarah Conway
17:00 - 17:30 - Closing Session