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 06
Mission
09:00 - 12:00
#1- Online Upgrades with Logical Replication (AM) (Free!)
Mark Wong, Shaun Thomas
12:15 - 13:15 - Lunch
13:30 - 16:30
#4 - Designing your Multi-tenant Database for Scale with Postgres (PM) (Free!)
Ozgun Erdogan, Sai Srirampur
Thursday, September 07
Cyril Magnin
07:30 - 08:30 - Breakfast!
08:30 - 08:35 - Opening -- Cyril Magnin Stephen Frost
08:35 - 08:55 - Guest Keynote -- Paul Vixie
09:00 - 09:20 - Keynote from Simon Riggs (2ndQuadrant) Simon Riggs
09:25 - 09:45 - Keynote from Ozgun Erdogan and Marco Slot (Citus Data) Marco Slot, Ozgun Erdogan
09:50 - 10:10 - Keynote from Rohan Kumar (Microsoft) Saloni Sonpal
10:10 - 10:25 - Coffee Break
10:30 - 11:20
A look at the Elephants trunk - PostgreSQL 10
Magnus Hagander
11:30 - 12:20
Postgres Window Magic
Bruce Momjian
12:30 - 13:20 - Lunch
13:30 - 14:20
Schrödinger's Elephant
Josh Berkus
14:30 - 15:20
PgBouncer and 20000 TPS at one node: advanced tuning, hacks and problem solving
Victor Yagofarov
15:30 - 15:50 - Coffee Break
16:00 - 16:50
An ultimate guide to upgrading your PostgreSQL installation
Ilya Kosmodemiansky
17:00 - 18:00 - Lightning Talks! -- Cyril Magnin
18:00 - 20:00 - Networking Reception! -- Exhibit Hall, Heavy hors d'oeuvres and Complimentary Beer and Wine
Market Street
07:30 - 08:30 - Breakfast!
08:30 - 08:35 - Opening -- Cyril Magnin Stephen Frost
08:35 - 08:55 - Guest Keynote -- Paul Vixie
09:00 - 09:20 - Keynote from Simon Riggs (2ndQuadrant) Simon Riggs
09:25 - 09:45 - Keynote from Ozgun Erdogan and Marco Slot (Citus Data) Marco Slot, Ozgun Erdogan
09:50 - 10:10 - Keynote from Rohan Kumar (Microsoft) Saloni Sonpal
10:10 - 10:25 - Coffee Break
10:30 - 11:20
Improving Postgres' Efficiency
Andres Freund
11:30 - 12:20
Securing PostgreSQL -- Exploring the PostgreSQL STIG and Beyond
Joe Conway, Sarah Conway
12:30 - 13:20 - Lunch
13:30 - 14:20
Concurrency Deep-Dive
Tejas Manohar
14:30 - 15:20
Human Beings Do Not Have a Primary Key
Christophe Pettus
15:30 - 15:50 - Coffee Break
16:00 - 16:50
PostgreSQL BI Performance & News from XL project
Mark Wong
17:00 - 18:00 - Lightning Talks! -- Cyril Magnin
18:00 - 20:00 - Networking Reception! -- Exhibit Hall, Heavy hors d'oeuvres and Complimentary Beer and Wine
Mission
07:30 - 08:30 - Breakfast!
08:30 - 08:35 - Opening -- Cyril Magnin Stephen Frost
08:35 - 08:55 - Guest Keynote -- Paul Vixie
09:00 - 09:20 - Keynote from Simon Riggs (2ndQuadrant) Simon Riggs
09:25 - 09:45 - Keynote from Ozgun Erdogan and Marco Slot (Citus Data) Marco Slot, Ozgun Erdogan
09:50 - 10:10 - Keynote from Rohan Kumar (Microsoft) Saloni Sonpal
10:10 - 10:25 - Coffee Break
10:30 - 11:20
Get to know Google Cloud SQL
Alexis Guajardo, Brett Hesterberg
11:30 - 12:20
Developing powerful and intelligent apps using the Azure managed PostgreSQL service
Saloni Sonpal, Sunil Kamath
12:30 - 13:20 - Lunch
13:30 - 14:20
Monitoring 101
Jason Yee
14:30 - 15:20
Best practices of using a managed PostgreSQL in the cloud
Jignesh Shah
15:30 - 15:50 - Coffee Break
16:00 - 16:50
Distributed COUNT(DISTINCT) with HyperLogLog on PostgreSQL
Burak Yucesoy
17:00 - 18:00 - Lightning Talks! -- Cyril Magnin
18:00 - 20:00 - Networking Reception! -- Exhibit Hall, Heavy hors d'oeuvres and Complimentary Beer and Wine
Friday, September 08
Cyril Magnin
08:00 - 09:00 - Breakfast!
09:00 - 09:50
PastgreSQL: Dead data tells all tales!
Samuel Elston, Srivathsava Rangarajan
10:00 - 10:20 - Coffee Break
10:30 - 11:20
PanLex: Using PostgreSQL to implement a massive word-translation graph
David Kamholz
11:30 - 12:20
Tuning PostgreSQL for High Write Workloads
Grant McAlister
12:30 - 13:20 - Lunch
13:30 - 14:20
Replication based Multi-Master solutions and design patterns
Tom Kincaid
14:30 - 15:20
How Postgres Could Index Itself
Andrew Kane
15:30 - 15:50 - Coffee Break
16:00 - 16:50
Logical Replication.... LIVE!
Robert Treat
17:00 - 17:30 - Closing Session
Market Street
08:00 - 09:00 - Breakfast!
09:00 - 09:50
The Immortal Postgres Web
Shaun Thomas
10:00 - 10:20 - Coffee Break
10:30 - 11:20
Scaling a Saas application beyond a single Postgres with Citus.
Jesse H. Willett
11:30 - 12:20
Scalable in-database machine learning with PL/Python
Srivatsan Ramanujam
12:30 - 13:20 - Lunch
13:30 - 14:20
Enhancements to the bitemporal model support: integrity constraints
Boris Novikov, Chad Slaughter, Henrietta Dombrovskaya
14:30 - 15:20
Beyond Foreign Data Wrappers: building a data warehouse from heterogeneous external data sources
Chad Slaughter
15:30 - 15:50 - Coffee Break
16:00 - 16:50
PostgreSQL, REST API’s and Rapid Application Development for Legacy Data
Charles Finley
17:00 - 17:30 - Closing Session
Mission
08:00 - 09:00 - Breakfast!
09:00 - 09:50
A Kubernetes Operator for PostgreSQL - Architecture and Design
Sarah Conway
10:00 - 10:20 - Coffee Break
10:30 - 11:20
ETL Confessions
Corey Huinker
11:30 - 12:20
PostgreSQL Security for Application Developers
Sehrope Sarkuni
12:30 - 13:20 - Lunch
13:30 - 14:20
Your database migrations are bad and you should feel bad
Robert Lechte
14:30 - 15:20
PostgreSQL as a distributed computing platform
Marco Slot
15:30 - 15:50 - Coffee Break
16:00 - 16:50
PostgreSQL at Pandora
Stephen Rees
17:00 - 17:30 - Closing Session