Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

PostgreSQL Sessions

Sponsor Percona Live Open Source Database Conference

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 (omniTI)
    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
    Lukas Fittl (Citus Data), Ozgun Erdogan (Citus Data)
    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.
    PostgreSQL Tools and Techniques Programming

4:50pm to 5:15pm

  • 4:50pm to 5:15pm
    Room 203
    • Business / Case Studies
    Christophe Pettus (PostgreSQL Experts Inc.)
    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.
    PostgreSQL
  • 4:50pm to 5:15pm
    Room 210
    • Business / Case Studies
    Denis Magda (GridGain)
    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.
    MySQL PostgreSQL Optimization
  • 12:50pm to 1:40pm
    Ballroom G
    • Operations
    • Developer
    Ilya Kosmodemiansky (Data Egret)
    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