4 ms·
The latest release has multi-threaded vacuuming so it goes much quicker these days.
by tankenmate 6y ago
The latest release has multi-threaded vacuuming so it goes much quicker these days.
- hrpnk 6y agoAside of auto vacuuming, there is also VACUUM FULL [1] which does an exclusive lock on the table. If you look for an alternative option for reorganizing tables in online mode, try the pg_repack extension [2]. [1] https://www.postgresql.org/docs/current/sql-vacuum.html https://www.postgresql.org/docs/current/sql-vacuum.html [2] https://reorg.github.io/pg_repack/ https://reorg.github.io/pg_repack/