Do you know about the pg_repack extension? How does it help with the VACUUM FULL problem?

Yes, the pg_repack extension is used to reorganize tables and indexes in PostgreSQL without locking write operations, which is an issue with VACUUM FULL. VACUUM FULL locks the table during execution, which can lead to downtime. pg_repack creates a new copy of the table with compacted data and then switches the links, minimizing lock time. This allows for efficient reduction of table size and elimination of fragmentation without significantly impacting database operation.