This release introduces a disk free space safety check to prevent reindex operations from running when there isn’t enough available space.
It adds a new -r, --disk-free-reserve option and implements filesystem-aware logic to locate the relevant data data and index tablespace directories and verify free space before processing each index.
Details: https://github.com/vitabaks/pg_auto_reindexer/releases/tag/v1.7
pg_auto_reindexer is a lightweight tool for automatic maintenance of PostgreSQL B-tree indexes.
It automatically detects bloated indexes and reindexes them with minimal locking, helping to maintain optimal database performance over time.