News for hackers. Stuff that matters.
Re:Oracle vs. PostgreSQL – A Comment by hrpnk on Saturday May 30, 2020 @01:05PM (#23362649)
Aside 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 [2] https://reorg.github.io/pg_repack/

There are no comments on this comment yet.