New Postgres extension: pg_squeeze
We've added pg_squeeze, a PostgreSQL extension that automatically cleans up unused space in tables (table bloat).
pg_squeeze runs as a background worker that periodically checks registered tables for bloat and performs automatic cleanup without blocking read/write operations. To use it, register tables by inserting records into the squeeze.tables table, then start the background worker with squeeze.start_worker(). Alternatively, you can process a table immediately with SELECT squeeze.squeeze_table('schema', 'table_name').
This extension is now available for all PlanetScale Postgres databases and can be enabled through the Extensions tab in your cluster configuration.