News for hackers. Stuff that matters.

A comment on Improved vacuum in PostgreSQL 13. Parent comment

Re:Improved vacuum in PostgreSQL 13 by dtech on Tuesday May 12, 2020 @07:20AM (#23152789)
Is that always the case? I'd expect that only to be necessary with a complete table rewrite, i.e. VACUUM FULL, which is not what (auto)VACUUM does by default.
[ Parent | on HN ]
Re:Improved vacuum in PostgreSQL 13 by heavenlyblue on Tuesday May 12, 2020 @08:07AM (#23153061)
Even with a full table rewrite, why do you need to rewrite to RAM?
[ Parent | on HN ]
Re:Improved vacuum in PostgreSQL 13 by hans_castorp on Tuesday May 12, 2020 @08:37AM (#23153276)
The "you must have a 1Gb free" refers to disk space, not main-memory (RAM).
[ Parent | on HN ]