Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

Autovacuum: Thresholds, Scale Factors and Per-Table Tuning

Lesson 14 of 21 Lab 🔒 Locked

Lessons in this course

  1. Reading EXPLAIN: The Planner's Cost ModelLabFree
  2. EXPLAIN ANALYZE: Actual Rows, Loops and MisestimatesLab Locked
  3. EXPLAIN BUFFERS: Pages, Cache Hits and ReadsLab Locked
  4. pg_stats: Most Common Values and n_distinctLab Locked
  5. Histograms: Estimating Range ConditionsLab Locked
  6. B-Tree Index or Seq Scan? The Break-Even PointLab Locked
  7. Multicolumn Indexes and the Leftmost PrefixLab Locked
  8. Covering Indexes, Index-Only Scans and the Visibility MapLab Locked
  9. Partial and Expression Indexes: Index Only What You QueryLab Locked
  10. GIN Indexes for Arrays, jsonb and Full TextLab Locked
  11. BRIN Indexes for Huge Append-Only TablesLab Locked
  12. HOT Updates and FillfactorLab Locked
  13. MVCC: xmin, xmax and Snapshot VisibilityLab Locked
  14. Autovacuum: Thresholds, Scale Factors and Per-Table TuningLab Locked
  15. Freezing and Transaction ID WraparoundLab Locked
  16. Isolation Levels and the Lost UpdateLab Locked
  17. Locks, Lock Queues and Safe MigrationsLab Locked
  18. Range Partitioning and Partition PruningLab Locked
  19. Roles, Privileges and Row Level SecurityLab Locked
  20. work_mem, Spills and the Memory BudgetLab Locked
  21. Final Project: Tuning from pg_stat_statementsLab Locked