Scott Mead

Sr. Database Engineer at AWS

About

Scott has been a PostgreSQL user, DBA, Developer & contributor for over 16 years. His focus is on production, his goal is to design systems allow for "always-on" maintenance and carrier-grade reliability.

    Scott Mead Connection scalability for Enterprise Applications
    Scale your database connectivity throughout the entire stack

    presented by Scott Mead

    Enterprise applications live and die by their ability to scale concurrently to the database. Choosing too few connections to your database gives your users a bad experience, choosing too many puts the database in a constant state of high CPU. Learn how to build a connection profile for your workload that provides maximum throughput and lowest latency while maximizing your database's system ut...

    more

    Fri 8 2022 AWS Data Day
    Scott Mead Schema management with Flyway
    Simplified schema management

    presented by Scott Mead


    video

    #Schema Management# Schema Management is a complex, multi-disciplinary topic that frequently typically stymies both Dev and Ops teams. In this talk, I will walk you through which practices do and don't work. We'll spend time looking at how a schema management tool Flyway can simplify your DevOps life.

    Development
    Scott Mead From Dev to prod, The ABC's of PostgreSQL backups
    Strategic Backup with PostgreSQL

    presented by Scott Mead


    video

    Most deployments of PostgreSQL start with a developer and a good idea. The good idea spreads and before you know it, you have a production system on your hands. We will cover the ABC's of PostgreSQL backups:

    • Logical Backups
    • Physical Backups
    • Incremental / Differential Backups
    • Optimizing for space
    • Available tools

    The trick is to leverage each of these in to a consistent...

    more

    Thu 30 2017 Operations
    Scott Mead Elegant Database Tuning
    Take your 'first-pass' config file to the next level with workload-specific tuning tips

    presented by Scott Mead

    The pg_catalog provides in-depth details of how your datamodel is being used. Follow along as we cruise the catalog to learn which indexes are never used, which indexes are missing and where we have over-normalized. Knowing how to analyze your database workload will allow you to make critical performance adjustments, inform your postgresql.conf and build an intelligent vacuum strategy. Catalog ...

    more

    Development