Online / 6 & 7 February 2021

schedule

PostgreSQL devroom


10 11 12 13 14 15 16 17
Saturday PostgreSQL Waffles Foreign data wrapper study for schemaless databases Database schema management for lazybones: from chaos to heaven Caveats of replication
in PostgreSQL HA clusters and CDC systems
The Story About The Migration
The story about a challenging PoC that proved that Postgres can achieve the same performance as Oracle Exadata
A PostgreSQL development environment Adaptive Query Optimization in PostgreSQL: approaches and challenges Performance improvements and new use scenarios for SPGiST access method Postgres and the Artificial Intelligence Landscape Database Performance at Gitlab.com
Sunday Some SQL Tricks of an Application DBA
Non-trivial tips for database development
Speed up the JSONB.
What we can do to improve performance.
I use ENUM - Vindicating the Underdog of Data Types Getting on a hook or PostgreSQL extensibility Postgres Architectures in Production PostgreSQL logical decoding PostgreSQL and The SQL Standard Improve your indexes PostgreSQL partitioning. Work In Progress. Changing your huge table's data types in production Stumbling Stones when migrating from Oracle
The problems you can encounter and how to solve them
Pg_stat_monitor - The new way to analyze query performance in PostgreSQL Database Disasters and How to Find Them The story of the first PGDay
How we started with the idea of having a barbecue and we ended in organising the first PostgreSQL conference in Europe

Read the Call for Papers at https://www.postgresql.org/about/news/postgresql-fosdem-2021-call-for-papers-2132/.

PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.

PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions. PostgreSQL runs on all major operating systems, has been ACID-compliant since 2001, and has powerful add-ons such as the popular PostGIS geospatial database extender. It is no surprise that PostgreSQL has become the open source relational database of choice for many people and organisations.

Getting started with using PostgreSQL has never been easier - pick a project you want to build, and let PostgreSQL safely and robustly store your data.

Event Speakers Start End

Saturday

  PostgreSQL Waffles Lætitia Avrot 10:00 11:00
  Foreign data wrapper study for schemaless databases Hiroki Kumagai 11:00 11:30
  Database schema management for lazybones: from chaos to heaven Julien Riou 11:30 12:30
  Caveats of replication
in PostgreSQL HA clusters and CDC systems
Andrey Borodin, Evgeny Dyukov 12:30 13:30
  The Story About The Migration
The story about a challenging PoC that proved that Postgres can achieve the same performance as Oracle Exadata
Alicja Kucharczyk, Sushant Pandey 13:30 14:00
  A PostgreSQL development environment Peter Eisentraut 14:00 15:00
  Adaptive Query Optimization in PostgreSQL: approaches and challenges Oleg Ivanov, Yerzhaisang Taskali 15:00 15:30
  Performance improvements and new use scenarios for SPGiST access method Pavel Borisov 15:30 16:00
  Postgres and the Artificial Intelligence Landscape Bruce Momjian 16:00 17:00
  Database Performance at Gitlab.com Nikolay Samokhvalov, Jose Finotto 17:00 18:00

Sunday

  Some SQL Tricks of an Application DBA
Non-trivial tips for database development
Haki Benita 10:00 10:30
  Speed up the JSONB.
What we can do to improve performance.
Oleg Bartunov, Nikita Glukhov 10:30 11:00
  I use ENUM - Vindicating the Underdog of Data Types Boriss Mejias 11:00 11:30
  Getting on a hook or PostgreSQL extensibility Alexey Kondratov 11:30 12:00
  Postgres Architectures in Production Dimitri Fontaine 12:00 12:30
  PostgreSQL logical decoding Amit Khandekar 12:30 13:00
  PostgreSQL and The SQL Standard Simon Riggs 13:00 13:30
  Improve your indexes Tomasz Gintowt 13:30 14:00
  PostgreSQL partitioning. Work In Progress. Anastasia Lubennikova 14:00 14:30
  Changing your huge table's data types in production Jimmy Angelakos 14:30 15:00
  Stumbling Stones when migrating from Oracle
The problems you can encounter and how to solve them
Laurenz Albe 15:00 15:30
  Pg_stat_monitor - The new way to analyze query performance in PostgreSQL Ibrar Ahmed, Peter Zaitsev 15:30 16:30
  Database Disasters and How to Find Them Christophe Pettus 16:30 17:30
  The story of the first PGDay
How we started with the idea of having a barbecue and we ended in organising the first PostgreSQL conference in Europe
Federico Campoli 17:30 18:00