From e205d12a8800aa5341f62f3117df5a40f0b57675 Mon Sep 17 00:00:00 2001 From: Ian Beckwith Date: Thu, 7 Oct 2010 20:02:27 +0100 Subject: [PATCH] VACUUM when pruning DB --- lib/ID3FS/DB.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/lib/ID3FS/DB.pm b/lib/ID3FS/DB.pm index 11429ac..9369fbf 100644 --- a/lib/ID3FS/DB.pm +++ b/lib/ID3FS/DB.pm @@ -812,6 +812,7 @@ sub remove_unused LEFT JOIN files_x_tags ON files_x_tags.tags_id=tags.id WHERE files_x_tags.files_id IS NULL); + VACUUM EOT print "SQL: $sql\n"; my @sql=split(/\n\n/, $sql); -- 2.11.0