Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

PostgreSQL Sessions

The Percona Live Open Source Database Conference Europe 2016 is the premier event for the rich and diverse PostgreSQL ecosystem in Europe.

PostgreSQL is a database server with an emphasis on extensibility and standards-compliance. It excels at data security, and providing data retrieval for other software applications. It handles workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Percona Live provides in-depth discussions for your PostgreSQL for high availability, IoT, cloud, big data and other changing business needs by tackling subjects such as analytics, architecture and design, security, operations, scalability and performance.

Below are the talks and tutorials covering PostgreSQL at this year’s conference.

11:20am to 12:10pm
Winterthur
  • OSDBMS
  • PostgreSQL
Oleksii Kliukin, Alexander Kukushkin
Zalando, Europe’s leading online fashion platform, trusts PostgreSQL to manage more than 15TB of data in total. While PostgreSQL is rock-solid and robust, it doesn't have built-in failover capabilities. In order to rapidly deploy and reliably run numerous PostgreSQL clusters on Amazon cloud and in existing data centers we've developed Patroni, a daemon to manage PostgreSQL.
Devops High Availability Replication
12:20pm to 1:10pm
Winterthur
  • PostgreSQL
  • MySQL
Dimitri Fontaine
Database migration projects are always articulated around the same steps, methodology and costs. At least when properly done. pgloader is meant to be disruptive in that market and offers to completely automate the “boring” parts.
MySQL Devops Tools and Techniques
2:10pm to 3:00pm
Winterthur
  • PostgreSQL
  • MySQL
Evan Klitzke
In 2013 Uber switched its relational database technology from MySQL 5.1 to Postgres 9.2. After running our business on Postgres for about two years we made the decision to migrate back to MySQL.
MySQL Other

3:10pm to 4:00pm

3:10pm to 4:00pm
Matterhorn 1
  • PostgreSQL
  • MySQL
Nicolai Plum
This talk will discuss the different orthogonal axes that data storage systems can be scaled up along. Most storage system designs can grow successfully in one or more of read rate, write rate, data size and data complexity. They cannot grow in all of these directions; modern highly scalable storage systems are a compromise.
MySQL Optimization Fundamentals
3:10pm to 4:00pm
Winterthur
  • OSDBMS
  • PostgreSQL
Ilya Kosmodemiansky
This talk is prepared as a bunch of slides, where each slide describes a really bad way people can screw up their PostgreSQL database and provides a weight - how frequently I saw that kind of problem. Right before the talk I will reshuffle the deck to draw ten random slides and explain you why such practices are bad and how to avoid running into them.
MySQL Other Fundamentals
4:20pm to 5:10pm
Winterthur
  • OSDBMS
  • PostgreSQL
Sveta Smirnova, Alexander Korotkov
It's widespread belief that SQL DBMSes are doomed to be hulking because of burden of backward compatibility. This belief is frequently used by marketing of various NoSQL DBMSes. However, this is not necessary true. Development in Open Source community makes product development flexible enough to meet needs of the times.
MySQL Other
5:20pm to 6:10pm
Winterthur
  • OSDBMS
  • PostgreSQL
Ilya Kosmodemiansky
Linux operating system has lots of tuning options which can change performance of your PostgreSQL installation drastically.
Other Optimization