# Supabase — Postgres Bloat Minimization

- Company: Supabase (supabase.com)
- Announced: 2024-04-26
- Category: not stated
- Coverage: not counted
- Announcement: no
- Group: routine
- Source: https://supabase.com/blog/postgres-bloat
- Record: https://forck.live/items/21428-postgres-bloat-minimization
- Subject: Supabase

Supabase published a guide on minimizing Postgres table bloat, explaining how heap storage and vacuuming work, and how to diagnose and address autovacuum failures. The post covers tuning autovacuum parameters, using VACUUM FULL or pg_repack, and handling long-running transactions that prevent cleanup.

## Evidence

Verbatim from https://supabase.com/blog/postgres-bloat:

> If the numbers differ by more than 2x, chances are that the autovacuum didn’t start or hasn’t completed for a table.

---

Record: https://forck.live/items/21428-postgres-bloat-minimization
Catalogue: https://forck.live/llms.txt
Current issue: https://forck.live/feed.md