PostgreSQL optimization tasks for ActiveRecord

optimization.rake

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}")
    end
  end

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

  desc "Reset PRIMARY KEY sequences "
  task :resetpk => :environment do
    tables = ActiveRecord::Base.connection.tables
    tables.each do |table|
      ActiveRecord::Base.connection.reset_pk_sequence!(table)
    end
  end
end