News for hackers. Stuff that matters.
Re:SQLite 3.32 by calpaterson on Saturday May 23, 2020 @04:50PM (#23286301)
Dropping a column in postgres is also instant, so yes, it uses the same trick.

Deleting a row is similar too - the row is not removed from the heap page and the database does not get smaller (though if that page gets rewritten the row is not kept). Last time I used innodb it didn't actually return free heap pages to the filesystem at all so no matter how much you deleted the database file never got smaller.

EDIT: Looks like that's still the case now: https://bugs.mysql.com/bug.php?id=1341

There are no comments on this comment yet.