Conference Sessions - PGConf.EU 2019

The following list contains all the talks that have been approved so far for PGConf.EU 2019. Note that they may not yet have been scheduled! You can find the full conference information at the conference website.

General

• 25 Interesting features of PostgreSQL 12 (Jobin Augustine)
• A Deep Dive into PostgreSQL Indexing (Ibrar Ahmed)
• Anonymization : GDPR and beyond (Damien Clochard)
• Community roadmap to sharding (Alexander Korotkov, Bruce Momjian)
• Converting 85% of Dutch primary schools from Oracle to PostgreSQL (Martijn Dashorst)
• Everything About PostGIS (Paul Ramsey)
• Exploratory analytics and Health Big Data on PostgreSQL (Ilaria Battiston)
• FDWs and their utilization in real world scenarios (Boriss Mejias)
• Fibonacci Spirals and 21 Ways to Contribute to Postgres—Beyond Code (Claire Giordano)
• Good data gone bad, bad data gone worse (Renee Phillips)
• In Aid of RTFM (Corey Huinker)
• Jsonpath in examples and its roadmap. (Nikita Glukhov, Oleg Bartunov)
• Marketing Postgres brand - where to start? (Valeria Kaplan)
• Postgres Women: what is it, why does it matter and what can everyone do about it? (Ilaria Battiston, Lætitia AVROT, Renee Phillips)
• Safely Protect Your Passwords and Tell Others to SCRAM! (Jonathan S. Katz)
• Using PostgreSQL as a Web Server and Content Management System (Tim Colles)
• Vacuum Through Pictures. (Tom Kincaid)
• What's wrong with Postgres (Craig Kerstiens)

PGConf.EU

• Lightning Talks (Dave Page, Harald Armin Massa)
• So long, and thanks for all the fish (Dave Page, Magnus Hagander)
• Welcome and Opening (Harald Armin Massa, Magnus Hagander, Vik Fearing)

DBA

• An Oracle DBA approach to troubleshoot PostgreSQL application performance (Franck Pachot)
• Barman in action (Gabriele Bartolini)
• Deploy your own replication system with Wal2Json (mai peng)
• Patroni in 2019: What's New and Future Plans (Alexander Kukushkin, Dmitry Dolgov)
• Performance analysis at full power (Julien Rouhaud)
• PgBouncer and a Bit of Queueing Theory (Peter Eisentraut)
• The unbreakable, scalable Elephant: Patroni automation with Ansible (Julia Gugel)
• You forgot to put the WHERE in the DELETE? (Martín Marqués)

Developer

• Ansible (really) loves PostgreSQL (Cédric Villemain)
• Be Inclusive: Welcome Non-key Columns in B-Tree Indexes (Markus Winand)
• Building iFood's content search platform with PostgreSQL (Matheus de Oliveira)
• Business Intelligence with Window Functions in PostgreSQL 11 (Gianni Ciolli)
• Caching long running queries (Laszlo Forro)
• Data Compression in PostgreSQL and its future (Iwata Aya)
• How Green Was My Valley - Spatial Analytics with PostgreSQL, PostGIS, R, and PL/R (Joe Conway)
• IoT with PostgreSQL (Chris Ellis)
• Make A New Command (David Fetter)
• May the Force of hierarchical data be with you (Fedor Sigaev)
• Meet NULL the UNKNOWN (Lætitia AVROT)
• More Than a Query Language: SQL in the 21st Century (Markus Winand)
• Postgres Partitioning: How Far We've Come (Amit Langote)
• The present and future of vacuum and autovacuum (Akenteva Anna)
• The TopN extension: Maintaining top 10 lists at scale (Furkan Sahin)
• When It All Goes Wrong (Will Leinweber)
• Wonderful SQL features your ORMs can use (or not) (Louise Grandjonc)
• ZedStore - Column store for PostgreSQL (Heikki Linnakangas)

Internals

• Beyond the pushdowns – distributed query planning and execution (Alexander Korotkov)
• Deep Postgres Extensions in Rust (Jeff Davis)
• How does HashJoin work in PostgreSQL and its derivates (Yandong Yao)
• Instantaneous transaction rollback, and other advantages of versioned storage (Peter Geoghegan)
• pg_pranks (Mladen Marinović)
• PostgreSQL's IO subsystem: Problems, Workarounds, Solutions (Andres Freund)
• What's in a Plan? (Robert Haas)

Training

• Implementing your first Postgres extension: from coding to distribution (Burak Yucesoy, Onder Kalaci)
• Migration to PostgreSQL (Jean-Christophe Arnu, Nicolas Lutic)
• PostgreSQL Business Continuity (Gianni Ciolli)
• PostgreSQL Security (Boriss Mejias)
• The "default" postgresql.conf, step by step (Ilya Kosmodemiansky)
• The PostgreSQL Optimizer and indexes unleashed (Hans-Jürgen Schönig)

Sponsors

• An Elephants Habitat (Alexander Sosna)
• An Expert Guide to Migrating Legacy Databases to Postgres in the Cloud (Marc Linster)
• BDR - AlwaysOn Multi-Master Clusters for Distributed PostgreSQL (Simon Riggs)
• DataGrip: a smart IDE for PostgreSQL (Maksim Sobolevskiy)
• Foreign tables modelling in UI (Serge Rider, Tatiana Krupenya)
• From full-time onsite DBA to remote expertise. A journey in effective PostgreSQL support (Stéphane Schildknecht)
• How many CPUs for 60000 TPS (Sebastiaan Alexander Mannem)
• How PostgreSQL tuning can profit from 20 years Oracle tuning (Hervé Schweitzer)
• Migrating to PostgreSQL (Boriss Mejias)
• Moving from Oracle to PostgreSQL (Hans-Jürgen Schönig)
• nbtree-indexes in PostgreSQL. Useful novelties. (Victor Yegorov)
• PostgreSQL under Windows (Pavlo Golub)

Platinum Sponsor Keynotes

• Growing the PostgreSQL Community (Simon Riggs)
• Supporting High-Security PostgreSQL (Hans-Jürgen Schönig)
• What Microsoft is doing with Postgres & the Citus Data acquisition (Utku Azman)
• Why Is This the Postgres Moment? (Ed Boyajian)