Hacker News new | ask | show | jobs
by jojobas 2214 days ago
Vacuuming is online, with some performance hit while it's underway.
2 comments
tankenmate 2214 days ago
The latest release has multi-threaded vacuuming so it goes much quicker these days.
link
hrpnk 2213 days ago
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/

link
kakwa_ 2213 days ago
Vacuum is online, but with a caveat iirc, it locks the table with a lock that does not block inserts/updates/reads. But if your application use exclusive locks, things can get blocked.
link