Presented by:

27b304f67c0cadfa2f37a19f01af8f89

Lukas Fittl

Citus Data

Creator of pganalyze.com, the Hosted PostgreSQL Performance Monitoring Tool.

Working with Citus Data on scaling out PostgreSQL. Previously helped out ProductHunt.com with their scaling efforts.

Author of pg_query (Ruby extension to parse queries using the raw_parser) and other tools. I love working with PostgreSQL statistics and visualizing them.

No video of the event yet, sorry!

To many developers the database is a black box. You expect to be able to put data into your database, have it to stay there, and get it out when you query it... hopefully in a performant manner. When its not performant enough the two options are usually add some indexes or throw some hardware at it.

We'll walk through a bit of a clearer guide of how you can understand how your database is doing from a 30,000 foot perspective as well as how your application needs to be changed over time to keep your database performant.

In particular we'll cover:

  • Postgres Caching & Indexing
  • How to read EXPLAIN Plans
  • Optimizing applications built on Django and Rails
  • Scaling to 10GB -> 100GB -> 1TB

Date:
2017 March 30 07:00
Duration:
50 min
Room:
Enterprise
Conference:
PGConf US 2017
Language:
English
Track:
Operations
Difficulty:
Medium