Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

PostgreSQL Sessions

Featured PostgreSQL Speakers

The Percona Live Open Source Database Conference 2017 has an excellent set of breakout sessions on PostgreSQL in our PostgreSQL track.

PostgreSQL is one of the most advanced enterprise-class open source databases, with features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions, and more.

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

  • 11:30am to 12:20pm
    Room 203
    • Operations
    payal singh
    Disaster recovery is perhaps the most ignored aspect of managing PostgreSQL in production systems, and its value is only realized in a moment of crisis. If not done right, absence of backup and recovery strategies can make one repent for days, if not months after a disaster.
    PostgreSQL Tools and Techniques Fundamentals
  • 2:20pm to 3:10pm
    Room 203
    • Developer
    Ozgun Erdogan, Lukas Fittl
    If you’re building a SaaS application, you probably already have the notion of tenancy built in your data model. Typically, most information relates to tenants / customers / accounts and your database tables capture this natural relation. With smaller amounts of data, it’s easy to throw more hardware at the problem and scale up your database.
    PostgreSQL Tools and Techniques Sharding
  • 3:50pm to 4:40pm
    Room 203
    • Developer
    Nikolay Samokhvalov
    Traditionally, many mobile and web developers consider using stored procedures as a very old and obvious anti-pattern. But time goes on, Open Source (R)DBMSs become stronger, and it is a good moment to look at stored procedures and triggers at different angle.
    Programming Tools and Techniques PostgreSQL

4:50pm to 5:15pm

  • 4:50pm to 5:15pm
    Room 203
    • Business / Case Studies
    Christophe Pettus
    Uber made waves in 2016 by publishing a paper describing their reasons for moving from PostgreSQL to MySQL. So, were they right? Mostly, no. We'll talk about the points they raise about PostgreSQL vs MySQL, and how they could have stayed on PostgreSQL while avoiding or mitigating the problems they faced... and honestly talk about how PostgreSQL can improve to meet their criticisms.
  • 4:50pm to 5:15pm
    Room 210
    • Business / Case Studies
    Denis Magda
    Learn how to boost performance 1,000x with in-memory store of petabytes of data for your MySQL-based applications. Apache Ignite is an in-memory computing platform that is built on top of a distributed key-value store and provides full-fledged SQL support.
    Optimization MySQL PostgreSQL
  • 12:50pm to 1:40pm
    Ballroom G
    • Operations
    • Developer
    Ilya Kosmodemiansky
    Input-output performance problems are on every day agenda for DBAs since the databases exist. Volume of data grows rapidly and you need to get your data fast from the disk and moreover - fast to the disk. For most databases there is a more or less easy to find checklist of recommended Linux settings to maximize IO throughput. In most cases that checklist is good enough.
    MySQL PostgreSQL Optimization