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
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)
- Writing blog posts on check_indexes & drop_indexes, R&D on load testing (April 4) (83:49)
- Rehearsing current modules, recording prep (April 7) (91:15)
- Recording single-table modules (April 11) (20:19)
- Writing indexing for joins (April 28) (91:49)
- Continuing indexing for joins + order by, writing labs (April 29 & 30) (98:51)
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