From: Rogan Hamby Date: Mon, 27 Feb 2017 13:37:56 +0000 (-0500) Subject: add vacuum analyze script for database maintenance in remove_ou scripts X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=69098fe858c7bc7c61de30af1f812f0ab5935dfe;hp=0f04d792ca52ef7a8c91853046c476b3b5daf37f add vacuum analyze script for database maintenance in remove_ou scripts --- diff --git a/remove_ou_data/17_vacuum_analyze.sql b/remove_ou_data/17_vacuum_analyze.sql new file mode 100644 index 0000000..1d60fb1 --- /dev/null +++ b/remove_ou_data/17_vacuum_analyze.sql @@ -0,0 +1,113 @@ +VACUUM ANALYZE VERBOSE acq.acq_lineitem_history ; +VACUUM ANALYZE VERBOSE acq.distribution_formula_entry ; +VACUUM ANALYZE VERBOSE acq.fund_allocation_percent ; +VACUUM ANALYZE VERBOSE acq.lineitem ; +VACUUM ANALYZE VERBOSE action.aged_circulation ; +VACUUM ANALYZE VERBOSE action.aged_hold_request ; +VACUUM ANALYZE VERBOSE action.circulation ; +VACUUM ANALYZE VERBOSE action.fieldset ; +VACUUM ANALYZE VERBOSE action.hold_request ; +VACUUM ANALYZE VERBOSE action.hold_transit_copy ; +VACUUM ANALYZE VERBOSE action.in_house_use ; +VACUUM ANALYZE VERBOSE action.non_cataloged_circulation ; +VACUUM ANALYZE VERBOSE action.non_cat_in_house_use ; +VACUUM ANALYZE VERBOSE action.transit_copy ; +VACUUM ANALYZE VERBOSE action_trigger.environment; +VACUUM ANALYZE VERBOSE action_trigger.event; +VACUUM ANALYZE VERBOSE action_trigger.event_definition; +VACUUM ANALYZE VERBOSE action_trigger.event_params; +VACUUM ANALYZE VERBOSE actor.address_alert ; +VACUUM ANALYZE VERBOSE actor.card ; +VACUUM ANALYZE VERBOSE actor.hours_of_operation ; +VACUUM ANALYZE VERBOSE actor.org_address ; +VACUUM ANALYZE VERBOSE actor.org_lasso_map ; +VACUUM ANALYZE VERBOSE actor.org_unit ; +VACUUM ANALYZE VERBOSE actor.org_unit_closed ; +VACUUM ANALYZE VERBOSE actor.org_unit_custom_tree_node ; +VACUUM ANALYZE VERBOSE actor.org_unit_proximity_adjustment ; +VACUUM ANALYZE VERBOSE actor.org_unit_setting ; +VACUUM ANALYZE VERBOSE actor.search_filter_group ; +VACUUM ANALYZE VERBOSE actor.stat_cat ; +VACUUM ANALYZE VERBOSE actor.stat_cat_entry ; +VACUUM ANALYZE VERBOSE actor.stat_cat_entry_default ; +VACUUM ANALYZE VERBOSE actor.stat_cat_entry_usr_map ; +VACUUM ANALYZE VERBOSE actor.toolbar ; +VACUUM ANALYZE VERBOSE actor.usr ; +VACUUM ANALYZE VERBOSE actor.usr_activity ; +VACUUM ANALYZE VERBOSE actor.usr_address ; +VACUUM ANALYZE VERBOSE actor.usr_message ; +VACUUM ANALYZE VERBOSE actor.usr_note ; +VACUUM ANALYZE VERBOSE actor.usr_org_unit_opt_in ; +VACUUM ANALYZE VERBOSE actor.usr_password_reset ; +VACUUM ANALYZE VERBOSE actor.usr_saved_search ; +VACUUM ANALYZE VERBOSE actor.usr_setting ; +VACUUM ANALYZE VERBOSE actor.usr_standing_penalty ; +VACUUM ANALYZE VERBOSE actor.workstation ; +VACUUM ANALYZE VERBOSE asset.call_number ; +VACUUM ANALYZE VERBOSE asset.copy ; +VACUUM ANALYZE VERBOSE asset.copy_location ; +VACUUM ANALYZE VERBOSE asset.copy_note ; +VACUUM ANALYZE VERBOSE asset.copy_part_map ; +VACUUM ANALYZE VERBOSE asset.copy_template ; +VACUUM ANALYZE VERBOSE asset.opac_visible_copies ; +VACUUM ANALYZE VERBOSE asset.stat_cat_entry_copy_map ; +VACUUM ANALYZE VERBOSE asset.uri_call_number_map ; +VACUUM ANALYZE VERBOSE auditor.actor_usr_address_history ; +VACUUM ANALYZE VERBOSE auditor.actor_usr_history ; +VACUUM ANALYZE VERBOSE auditor.asset_call_number_history ; +VACUUM ANALYZE VERBOSE auditor.asset_copy_history ; +VACUUM ANALYZE VERBOSE authority.bib_linking ; +VACUUM ANALYZE VERBOSE biblio.monograph_part ; +VACUUM ANALYZE VERBOSE biblio.peer_bib_copy_map ; +VACUUM ANALYZE VERBOSE biblio.record_entry ; +VACUUM ANALYZE VERBOSE booking.reservation ; +VACUUM ANALYZE VERBOSE booking.resource ; +VACUUM ANALYZE VERBOSE booking.resource_attr ; +VACUUM ANALYZE VERBOSE booking.resource_attr_value ; +VACUUM ANALYZE VERBOSE booking.resource_type ; +VACUUM ANALYZE VERBOSE config.barcode_completion ; +VACUUM ANALYZE VERBOSE config.circ_limit_set ; +VACUUM ANALYZE VERBOSE config.circ_matrix_matchpoint ; +VACUUM ANALYZE VERBOSE config.filter_dialog_filter_set ; +VACUUM ANALYZE VERBOSE config.floating_group_member ; +VACUUM ANALYZE VERBOSE config.hold_matrix_matchpoint ; +VACUUM ANALYZE VERBOSE config.idl_field_doc ; +VACUUM ANALYZE VERBOSE config.org_unit_setting_type_log ; +VACUUM ANALYZE VERBOSE config.remote_account ; +VACUUM ANALYZE VERBOSE config.weight_assoc ; +VACUUM ANALYZE VERBOSE config.z3950_source_credentials ; +VACUUM ANALYZE VERBOSE metabib.browse_entry_def_map ; +VACUUM ANALYZE VERBOSE metabib.record_attr_vector_list ; +VACUUM ANALYZE VERBOSE metabib.record_sorter ; +VACUUM ANALYZE VERBOSE money.billable_xact ; +VACUUM ANALYZE VERBOSE money.billing; +VACUUM ANALYZE VERBOSE money.bnm_desk_payment; +VACUUM ANALYZE VERBOSE money.cash_payment; +VACUUM ANALYZE VERBOSE money.check_payment; +VACUUM ANALYZE VERBOSE money.collections_tracker ; +VACUUM ANALYZE VERBOSE money.credit_card_payment; +VACUUM ANALYZE VERBOSE money.credit_payment; +VACUUM ANALYZE VERBOSE money.forgive_payment; +VACUUM ANALYZE VERBOSE money.goods_payment; +VACUUM ANALYZE VERBOSE money.grocery ; +VACUUM ANALYZE VERBOSE money.materialized_billable_xact_summary ; +VACUUM ANALYZE VERBOSE money.payment; +VACUUM ANALYZE VERBOSE money.work_payment; +VACUUM ANALYZE VERBOSE permission.grp_penalty_threshold ; +VACUUM ANALYZE VERBOSE permission.usr_work_ou_map ; +VACUUM ANALYZE VERBOSE reporter.output_folder ; +VACUUM ANALYZE VERBOSE reporter.report ; +VACUUM ANALYZE VERBOSE reporter.report_folder ; +VACUUM ANALYZE VERBOSE reporter.schedule ; +VACUUM ANALYZE VERBOSE reporter.template ; +VACUUM ANALYZE VERBOSE reporter.template_folder ; +VACUUM ANALYZE VERBOSE serial.distribution ; +VACUUM ANALYZE VERBOSE serial.record_entry ; +VACUUM ANALYZE VERBOSE serial.subscription ; +VACUUM ANALYZE VERBOSE vandelay.import_bib_trash_group ; +VACUUM ANALYZE VERBOSE vandelay.import_item ; +VACUUM ANALYZE VERBOSE vandelay.import_item_attr_definition ; +VACUUM ANALYZE VERBOSE vandelay.match_set ; +VACUUM ANALYZE VERBOSE vandelay.merge_profile ; +VACUUM ANALYZE VERBOSE vandelay.queue ; +VACUUM ANALYZE VERBOSE vandelay.queued_bib_record ;