SQLite Forum

autovacuum in sqlite VS autovacuum in PG
Login
So for sqlite, 

1. does update/delete operation cause sqlite generate multiple copies of each record or just one copy ? (update-in-place or not ?)
2. delete is easier to create freelist pages than update, so delete facilitates shrink of database file much more than update ?