News for hackers. Stuff that matters.

A comment on It's 2026, Just Use Postgres. Parent comment

Re:It's 2026, Just Use Postgres by KlayLay on Thursday February 05, 2026 @08:21PM (#46907807)
I agree that SQLite requires less maintenance, but you still need to vacuum to prevent the database file from accumulating space (for apps, I run VACUUM at startup).
[ Parent | on HN ]
Re:It's 2026, Just Use Postgres by direwolf20 on Thursday February 05, 2026 @09:35PM (#46908311)
SQLite vacuum is only needed to shrink the database after you remove a lot of data. It's not needed in routine operations like postgres does. Postgres has autovacuum usually on by default so I'm not understanding the complaint much
[ Parent | on HN ]