merqlove

namespace :optimization do
  desc "Provide DB vacuum for production environment"
  task :vacuum => :environment do
    begin
      tables = ActiveRecord::Base.connection.tables
      tables.each do |table|
        ActiveRecord::Base.connection.execute("VACUUM FULL ANALYZE #{table};")
      end
    rescue Exception => exc
      Rails.logger.error("Database VACUUM error: #{exc.message}")