News for hackers. Stuff that matters.

A comment on Oracle vs. PostgreSQL – A Comment.

Re:Oracle vs. PostgreSQL – A Comment by 978e4721a on Saturday May 30, 2020 @11:37AM (#23361862)
Is vacuumin postgres still basically means that you need downtime?
[ Parent | on HN ]
Re:Oracle vs. PostgreSQL – A Comment by jojobas on Saturday May 30, 2020 @11:44AM (#23361915)
Vacuuming is online, with some performance hit while it's underway.
[ Parent | on HN ]
Re:Oracle vs. PostgreSQL – A Comment by tankenmate on Saturday May 30, 2020 @12:11PM (#23362114)
The latest release has multi-threaded vacuuming so it goes much quicker these days.
[ Parent | on HN ]
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/

[ Parent | on HN ]
Re:Oracle vs. PostgreSQL – A Comment by kakwa_ on Saturday May 30, 2020 @01:02PM (#23362610)
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.
[ Parent | on HN ]