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