CYBERTEC PostgreSQL International GmbH

The PostgreSQL Optimizer and indexes unleashed

Tue. 09:00–17:00 — Foscolo

Hans-Jürgen Schönig 

 EDB

PostgreSQL Security

Tue. 09:00–12:30 — Parini

Boriss Mejias 

 EDB

PostgreSQL Business Continuity

Tue. 09:00–17:00 — Porta

Gianni Ciolli 

 LOXODATA

Migration to PostgreSQL

Tue. 09:00–12:30 — Monti

Jean-Christophe Arnu, Nicolas Lutic 

 Data Egret

The "default" postgresql.conf, step by step

Tue. 13:30–17:00 — Parini

Ilya Kosmodemiansky 

 Ubicloud

Implementing your first Postgres extension: from coding to distribution

Tue. 13:30–17:00 — Monti

Burak Yucesoy , Onder Kalaci

  Welcome and Opening

Wed. 09:30–09:45 — Washington

Harald Armin Massa , Magnus Hagander , Vik Fearing 

Safely Protect Your Passwords and Tell Others to SCRAM!

Wed. 09:50–10:40 — Washington

Jonathan S. Katz 

Performance analysis at full power

Wed. 09:50–10:40 — Manzoni

Julien Rouhaud 

In Aid of RTFM

Wed. 09:50–10:40 — Foscolo

Corey Huinker

Everything About PostGIS

Wed. 10:50–11:40 — Washington

Paul Ramsey 

Meet NULL the UNKNOWN

Wed. 10:50–11:40 — Manzoni

Lætitia AVROT 

Fibonacci Spirals and 21 Ways to Contribute to Postgres—Beyond Code

Wed. 10:50–11:40 — Foscolo

Claire Giordano 

 DByond

How many CPUs for 60000 TPS

Wed. 10:50–11:40 — Parini

Sebastiaan Alexander Mannem 

Be Inclusive: Welcome Non-key Columns in B-Tree Indexes

Wed. 12:00–12:50 — Washington

Markus Winand 

Barman in action

Wed. 12:00–12:50 — Manzoni

Gabriele Bartolini 

Marketing Postgres brand - where to start?

Wed. 12:00–12:50 — Foscolo

Valeria Kaplan

 CYBERTEC

PostgreSQL under Windows

Wed. 12:00–12:50 — Parini

Pavlo Golub 

Jsonpath in examples and its roadmap.

Wed. 13:00–13:50 — Washington

Nikita Glukhov, Oleg Bartunov

Beyond the pushdowns – distributed query planning and execution

Wed. 13:00–13:50 — Manzoni

Alexander Korotkov 

A Deep Dive into PostgreSQL Indexing

Wed. 13:00–13:50 — Foscolo

Ibrar Ahmed 

 LOXODATA

From full-time onsite DBA to remote expertise. A journey in effective PostgreSQL support

Wed. 13:00–13:50 — Parini

Stéphane Schildknecht 

25 Interesting features of PostgreSQL 12

Wed. 14:40–15:30 — Washington

Jobin Augustine 

The present and future of vacuum and autovacuum

Wed. 14:40–15:30 — Manzoni

Akenteva Anna

Caching long running queries

Wed. 14:40–15:30 — Foscolo

Laszlo Forro

 Data Egret

nbtree-indexes in PostgreSQL. Useful novelties.

Wed. 14:40–15:30 — Parini

Victor Yegorov

PostgreSQL's IO subsystem: Problems, Workarounds, Solutions

Wed. 15:40–16:30 — Washington

Andres Freund 

Good data gone bad, bad data gone worse

Wed. 15:40–16:30 — Manzoni

Renee Phillips 

Data Compression in PostgreSQL and its future

Wed. 15:40–16:30 — Foscolo

Iwata Aya

 EDB

Migrating to PostgreSQL

Wed. 15:40–16:30 — Parini

Boriss Mejias 

Patroni in 2019: What's New and Future Plans

Wed. 17:00–17:50 — Washington

Alexander Kukushkin , Dmitry Dolgov

Deep Postgres Extensions in Rust

Wed. 17:00–17:50 — Manzoni

Jeff Davis

Ansible (really) loves PostgreSQL

Wed. 17:00–17:50 — Foscolo

Cédric Villemain

 DBeaver Corp

Foreign tables modelling in UI

Wed. 17:00–17:50 — Parini

Serge Rider, Tatiana Krupenya 

Postgres Partitioning: How Far We've Come

Thu. 09:30–10:20 — Washington

Amit Langote 

How Green Was My Valley - Spatial Analytics with PostgreSQL, PostGIS, R, and PL/R

Thu. 09:30–10:20 — Manzoni

Joe Conway 

pg_pranks

Thu. 09:30–10:20 — Foscolo

Mladen Marinović 

 CYBERTEC PostgreSQL International GmbH

Moving from Oracle to PostgreSQL

Thu. 09:30–10:20 — Parini

Hans-Jürgen Schönig 

Community roadmap to sharding

Thu. 10:30–11:20 — Washington

Alexander Korotkov , Bruce Momjian

Wonderful SQL features your ORMs can use (or not)

Thu. 10:30–11:20 — Manzoni

Louise Grandjonc 

Business Intelligence with Window Functions in PostgreSQL 11

Thu. 10:30–11:20 — Foscolo

Gianni Ciolli 

 EnterpriseDB

An Expert Guide to Migrating Legacy Databases to Postgres in the Cloud

Thu. 10:30–11:20 — Parini

Marc Linster 

When It All Goes Wrong

Thu. 11:50–12:40 — Washington

Will Leinweber

Instantaneous transaction rollback, and other advantages of versioned storage

Thu. 11:50–12:40 — Manzoni

Peter Geoghegan 

The TopN extension: Maintaining top 10 lists at scale

Thu. 11:50–12:40 — Foscolo

Furkan Sahin 

 dbi services

How PostgreSQL tuning can profit from 20 years Oracle tuning

Thu. 11:50–12:40 — Parini

Hervé Schweitzer 

ZedStore - Column store for PostgreSQL

Thu. 12:50–13:40 — Washington

Heikki Linnakangas 

Vacuum Through Pictures.

Thu. 12:50–13:40 — Manzoni

Tom Kincaid 

How does HashJoin work in PostgreSQL and its derivates

Thu. 12:50–13:40 — Foscolo

Yandong Yao

 EDB

BDR - AlwaysOn Multi-Master Clusters for Distributed PostgreSQL

Thu. 12:50–13:40 — Parini

Simon Riggs

More Than a Query Language: SQL in the 21st Century

Thu. 14:40–15:30 — Washington

Markus Winand 

Exploratory analytics and Health Big Data on PostgreSQL

Thu. 14:40–15:30 — Manzoni

Ilaria Battiston

Deploy your own replication system with Wal2Json

Thu. 14:40–15:30 — Foscolo

mai peng 

 JetBrains

DataGrip: a smart IDE for PostgreSQL

Thu. 14:40–15:30 — Parini

Maksim Sobolevskiy 

An Oracle DBA approach to troubleshoot PostgreSQL application performance

Thu. 15:40–16:30 — Washington

Franck Pachot 

IoT with PostgreSQL

Thu. 15:40–16:30 — Manzoni

Chris Ellis

Anonymization : GDPR and beyond

Thu. 15:40–16:30 — Foscolo

Damien Clochard 

 GitLab

An Elephants Habitat

Thu. 15:40–16:30 — Parini

Alexander Sosna 

  Lightning Talks

Thu. 17:00–17:50 — Washington

Dave Page, Harald Armin Massa 

What's in a Plan?

Fri. 09:30–10:20 — Washington

Robert Haas 

Postgres Women: what is it, why does it matter and what can everyone do about it?

Fri. 09:30–10:20 — Manzoni

Ilaria Battiston, Lætitia AVROT , Renee Phillips 

PgBouncer and a Bit of Queueing Theory

Fri. 09:30–10:20 — Foscolo

Peter Eisentraut

You forgot to put the WHERE in the DELETE?

Fri. 10:50–11:40 — Washington

Martín Marqués 

May the Force of hierarchical data be with you

Fri. 10:50–11:40 — Manzoni

Fedor Sigaev

Using PostgreSQL as a Web Server and Content Management System

Fri. 10:50–11:40 — Foscolo

Tim Colles

The unbreakable, scalable Elephant: Patroni automation with Ansible

Fri. 11:50–12:40 — Washington

Julia Gugel

FDWs and their utilization in real world scenarios

Fri. 11:50–12:40 — Manzoni

Boriss Mejias 

Make A New Command

Fri. 11:50–12:40 — Foscolo

David Fetter 

What's wrong with Postgres

Fri. 13:40–14:30 — Washington

Craig Kerstiens 

Building iFood's content search platform with PostgreSQL

Fri. 13:40–14:30 — Manzoni

Matheus de Oliveira

Converting 85% of Dutch primary schools from Oracle to PostgreSQL

Fri. 13:40–14:30 — Foscolo

Martijn Dashorst 

 Microsoft

What Microsoft is doing with Postgres & the Citus Data acquisition

Fri. 15:00–15:20 — Washington

Utku Azman

 EDB

Growing the PostgreSQL Community

Fri. 15:25–15:45 — Washington

Simon Riggs

 CYBERTEC PostgreSQL International GmbH

Supporting High-Security PostgreSQL

Fri. 15:50–16:10 — Washington

Hans-Jürgen Schönig 

 EnterpriseDB

Why Is This the Postgres Moment?

Fri. 16:15–16:35 — Washington

Ed Boyajian

  So long, and thanks for all the fish

Fri. 16:40–17:10 — Washington

Dave Page, Magnus Hagander