Get in early and save big.
Get exclusive live streaming access as Brent builds the open source Box of Tricks scripts, the new Fundamentals of Select class, Fundamentals of Vacuum, and more.
Videos Ready to Watch Now
Introduction
Available in
days
days
after you enroll
Live Streams
Available in
days
days
after you enroll
Fundamentals of Vacuum: Completed Modules
Available in
days
days
after you enroll
- How Postgres Stores Data in 8KB Pages (12:05)
- Unvacuumed Tables are Bigger and Slower (14:20)
- How Indexes are Affected Too (12:13)
- What Autovacuum Does - and Doesn't Do (10:50)
- Autovacuum Problem 1: Many Active Tables (16:33)
- Autovacuum Problem 2: Blocking on a Single Table (12:27)
- Autovacuum Problem 3: Transaction ID Wraparounds (Early Access, Work In Progress)
- Manual Vacuums: When Autovacuum Can't Keep Up (Early Access, Work In Progress)
Live Stream Archives: Building Fundamentals of Index Tuning
Available in
days
days
after you enroll
- Designing & setting up the class (76:19)
- Learning how to read buffers output of explain (85:46)
- R&D: reading RSS feeds, writing SmartPostgres.com newsletters (70:33)
- Writing module 1: which columns to index (March 24) (82:48)
- Testing the first module, starting the partial indexes module (March 25) (89:10)
- Writing modules for filtered indexes, indexing timestamp columns with functional indexes (March 26) (61:44)
- Writing modules for indexing for group by, indexing for joins (March 28) (82:31)
- Writing modules for order by (March 31) (72:13)
- Writing lab exercises for attendees (April 2) (56:09)
- Rehearsing current modules to see what we need to add (April 3) (81:03)
Live Stream Archives: Building Fundamentals of Python
Available in
days
days
after you enroll
Live Stream Archives: Building Fundamentals of Vacuum
Available in
days
days
after you enroll
- Research, picking storytelling method (107:44)
- Measuring impact on selects (94:43)
- Rehearsing first 4 modules (122:44)
- Building load test to cause autovacuum problems (111:34)
- Writing modules for problems with autovacuum (92:55)
- Recording modules for problems with autovacuum (10:14)
- R&D for how to measure when autovacuum isn't keeping up (95:31)
- Writing fill factor table module (101:30)
- Writing fill factor table module, continued (56:46)
- Writing fill factor table module, continued (85:09)
- Writing fill factor table module, continued (86:38)
- Why I'm taking a mental health day (Feb 3) (11:00)
Live Stream Archives: Building check_indexes
Available in
days
days
after you enroll
- Design: sp_BlitzIndex design review, check_indexes proof of concept (92:13)
- Creating "bad" schema, debugging (175:01)
- Fetching data for base tables and TOAST tables (113:13)
- Turning check_indexes into a function (149:22)
- Adding partitioned table support, writing our first warning (142:33)
- Updating check_indexes (101:43)
- Adding drop commands, merging pull requests (117:55)
- Handling pull requests, planning for autovacuum warnings (68:02)
- Coding autovacuum warnings (91:08)
- Coding autovacuum warnings, continued (96:07)
- Blogging about materialized views (70:17)
- Enhancing & debugging autovacuum warnings (77:32)
- Testing check_indexes on Postgres 12-17 (32:38)
- Dynamic SQL, adding more info to check_indexes output (77:12)
- Writing supporting web pages, Github readme (67:58)
- Adding bloat checks (92:51)
- Giving up on bloat checks, trying other free database tools (94:47)
- Adding transaction ID wraparound warning for check_indexes (Feb 13) (84:55)
Live Stream Archives: Building Fundamentals of Selects
Available in
days
days
after you enroll