Live Streams
Fundamentals of Vacuum: Completed Modules
-
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
-
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)
Live Stream Archives: Building Fundamentals of Python
Live Stream Archives: Building Fundamentals of Vacuum
-
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
-
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
