Postgres: bloat, pg_repack, and deferred constraints
The table and index bloat effect is widely known and is not limited to Postgres. There are 'out-of-the-box' methods to combat it, such as VACUUM FULL or CLUSTER, but these lock tables during operation and therefore cannot always be used. This article will cover some theory on how bloat occurs, how it can be addressed, […]
