From: Ian Beckwith Date: Thu, 7 Oct 2010 19:02:27 +0000 (+0100) Subject: VACUUM when pruning DB X-Git-Tag: debian/1.0-1~122 X-Git-Url: http://erislabs.net/gitweb/?p=id3fs.git;a=commitdiff_plain;h=e205d12a8800aa5341f62f3117df5a40f0b57675 VACUUM when pruning DB --- 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);