Scott Mead
Sr. Database Engineer at AWS
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.
Upcoming presentations
No upcoming presentations...
Past presentations
- Logical Backups
- Physical Backups
- Incremental / Differential Backups
- Optimizing for space
- Available tools
Connection scalability for Enterprise Applications
Scale your database connectivity throughout the entire stack
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...
Apr 8 2022
Schema management with Flyway
Simplified schema management
#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.
From Dev to prod, The ABC's of PostgreSQL backups
Strategic Backup with PostgreSQL
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:
The trick is to leverage each of these in to a consistent...
Elegant Database Tuning
Take your 'first-pass' config file to the next level with workload-specific tuning tips
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 ...