Lukas Fittl

Principal Cloud Engineer at Citus Data

About

Principal Engineer on the Citus Cloud team at Citus Data, developing and operating a distributed PostgreSQL-as-a-Service.

Creator of pganalyze.com, hosted PostgreSQL Performance Monitoring, 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.

Lukas Fittl has presented the following presentations

    Ozgun Erdogan Lukas Fittl Designing a Multi-tenant Database for Scale with PostgreSQL at PGConf US 2017 [PgConf.US]

    presented by Ozgun Erdogan and 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 (10s of GB), it’s easy to throw more hardware at the problem and scale up your database. As these tables grow however, you need to th...

    more

    Training
    Lukas Fittl Postgres Performance for Application Developers at PGConf US 2017 [PgConf.US]

    presented by Lukas Fittl

    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 i...

    more

    Operations
    Lukas Fittl Practical Lessons Learned when using PostgreSQL at a Web Startup at PGConf US 2016 [PgConf.US]

    presented by Lukas Fittl

    PostgreSQL is a great database - yet there is an interesting set of issues you encounter when you have a team of developers working with an ever changing schema. At Product Hunt we've been using PostgreSQL as the main database since our launch in 2013 - and since then have encountered many smaller problems that we've had to deal with as we've grown, as well as making sure we get close to 100% u...

    more

    Use Cases
    Lukas Fittl Advanced use of pg_stat_statements: Filtering, Regression Testing & More at PGConf US 2015 [PgConf.US]

    presented by Lukas Fittl

    This talk will go into lessons learned when using the pg_stat_statements extension for collecting query statistics, and present new open-source tools we’ve developed for working with the extension output: pg_query: A Ruby extension to parse SQL queries into parse trees using the PostgreSQL parser. This can be used for filtering pg_stat_statements output (e.g. finding all queries on a certain ta...

    more

    General
    Lukas Fittl Monitoring PostgreSQL at Scale at PostgresConf US 2018
    How to monitor production databases for query performance, high availability, and more

    presented by Lukas Fittl

    Your PostgreSQL database is one of the most important pieces of your architecture - yet the level of introspection available in Postgres is often hard to work with. Its easy to get very detailed information, but what should you really watch out for, send reports on and alert on?

    In this talk we'll discuss how query performance statistics can be made accessible to application developers, crit...

    more

    Operations and Administration