3 ms·
Had this exact same idea but I wonder how does it handle deletes. Is it actually going to release deleted unused space or would be a manual defragmentation aft
by evnix 2y ago
Had this exact same idea but I wonder how does it handle deletes.
Is it actually going to release deleted unused space or would be a manual defragmentation after some deletes.
- ectospheno 2y agoSet the auto_vacuum pragma before creating any tables?
- kevincox 2y agoThe db size generally won't shrink under default settings, but the space will be reused.