Schedule - PGCon 2020

You can find the full conference information at the conference website. This schedule is subject to changes. This page will be updated when any changes occur.

Tuesday, May 26

Stream 1
09:00 - 11:00
The "default" postgresql.conf, step by step
Ilya Kosmodemiansky
11:30 - 13:30
Advanced Data Modeling Techniques in PostgreSQL
Christopher Travers
14:00 - 16:00
Seamless SQL optimization
Nikolay Samokhvalov

Wednesday, May 27

Stream 1
Stream 2
Stream 3
08:45 - 09:00
Opening session
Dan Langille
09:00 - 09:45
Improve of Parallel Query when getting large scale records
Shigeo Hirose
09:00 - 09:45
Find your slow queries, and fix them!
Stephen Frost
09:00 - 09:45
Deep Thoughts: Betting on Security
Joe Conway
10:00 - 10:45
DIY: database index
Andrey Borodin
10:00 - 10:45
Protect Your PostgreSQL Passwords: How SCRAM Works and Why You Need It
Jonathan S. Katz
10:00 - 10:45
Community roadmap to sharding
Alexander Korotkov
11:00 - 11:45
Implementing System Versioned Temporal Table
Surafel Temesgen
11:00 - 11:45
Building Better Benchmarks
Mark Wong
11:00 - 11:45
Hacking the Query Planner, Again
Richard Guo
13:00 - 13:45
pgagroal
Jesper Pedersen
13:00 - 13:45
Ptrack 2.0: yet another block-level incremental backup engine
Alexey Kondratov
13:00 - 13:45
Toward full ACID distributed transaction support with Foreign Data Wrapper
Masahiko Sawada
14:00 - 14:45
work_mem warriors: Teaching HashAgg, HashJoin, and Other Memory-Intensive Operators to Respect work_mem's Boundaries
Jeff Davis, Melanie Plageman
14:00 - 14:45
Zedstore - In-core Column Store for Postgres
Alexandra Wang, Soumyadeep Chakraborty
14:00 - 14:45
PostgreSQL HA Cluster with Query Load Balancing on Kubernetes
Bo Peng

Thursday, May 28

Stream 1
Stream 2
Stream 3
09:00 - 09:45
PostgreSQL on K8s at Zalando: Two years in production
Alexander Kukushkin
09:00 - 09:45
Mechanical Sympathy for Elephants: Reducing I/O and Memory Stalls
Thomas Munro
09:00 - 09:45
Choose Your Own Adventure Postgres 12 By Example
Robert Treat
10:00 - 10:45
Distributed snapshots and global deadlock detection
Asim Rama Praveen, Hubert Zhang
10:00 - 10:45
What's Missing For Postgres Monitoring
Lukas Fittl
10:00 - 10:45
Building automatic adviser and performance tuning tools in PostgreSQL
Julien Rouhaud, Tatsuro Yamada
12:00 - 12:45
CREATE STATISTICS - what is it for
Tomas Vondra
12:00 - 12:45
Asynchronous IO for PostgreSQL
Andres Freund
12:00 - 12:45
JSON[b] Roadmap
Oleg Bartunov
13:00 - 13:45
The Way for Updating Materialized Views Rapidly
Takuma Hoshiai, Yugo Nagata
13:00 - 13:45
Avoiding, Detecting, and Recovering From Data Corruption
Robert Haas
13:00 - 13:45
Time Series Databases: A Deeper Look
Peter Eisentraut
14:00 - 14:45
Progress adding SQL:2011 valid time to Postgres
Paul A. Jungwirth
14:00 - 14:45
Introducing LSM-tree into PostgreSQL, making it as a data gobbler
Shichao Jin
15:00 - 15:45
Closing session
Dan Langille

Friday, May 29

Stream 1
Stream 2
Stream 3
10:00 - 11:00
Unconference - Session Pitches and Scheduling
11:15 - 12:15
Unconference Room #2
11:15 - 12:15
Unconference Room #1
11:15 - 12:15
Unconference Room #3
13:15 - 14:15
Unconference Room #2
13:15 - 14:15
Unconference Room #3
13:15 - 14:15
Unconference Room #1
14:30 - 15:30
Unconference Room #3
14:30 - 15:30
Unconference Room #2
14:30 - 15:30
Unconference Room #1
15:45 - 16:45
Unconference Room #3
15:45 - 16:45
Unconference Room #1
15:45 - 16:45
Unconference Room #2

Tracks

Community
DBA
Case Studies
New Features
Plenary
Scaling Out
Tutorial
Unconference