> You can VACUUM INTO, but standard vacuum won’t rewrite the whole db. This is n... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		return_to_monke 4 months ago \| parent \| context \| favorite \| on: SQLite concurrency and why you should care about i... > You can VACUUM INTO, but standard vacuum won’t rewrite the whole db. This is not true. From the link you posted: > The VACUUM command works by copying the contents of the database into a temporary database file and then overwriting the original with the contents of the temporary file.

mceachen 4 months ago [–]

Ugh, you’re totally right.

I always get optimize and vacuum mixed up.

https://sqlite.org/pragma.html#pragma_optimize

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact