From fd5875c0d61da5e43f5539e188a451649768d646 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Fri, 9 Feb 2018 08:44:59 -0500 Subject: [PATCH] start of distinct acq removal file --- remove_ou_data/16_delete_usrs_stage_1.sql | 42 ----------- remove_ou_data/16_delete_usrs_stage_3.sql | 29 -------- remove_ou_data/16_remove_acq.sql | 30 ++++++++ remove_ou_data/17_delete_usrs_stage_1.sql | 42 +++++++++++ remove_ou_data/17_delete_usrs_stage_3.sql | 29 ++++++++ remove_ou_data/17_vacuum_analyze.sql | 113 ----------------------------- remove_ou_data/18_vauum_analyze.sql | 113 +++++++++++++++++++++++++++++ 7 files changed, 214 insertions(+), 184 deletions(-) delete mode 100644 remove_ou_data/16_delete_usrs_stage_1.sql delete mode 100644 remove_ou_data/16_delete_usrs_stage_3.sql create mode 100644 remove_ou_data/16_remove_acq.sql create mode 100644 remove_ou_data/17_delete_usrs_stage_1.sql create mode 100644 remove_ou_data/17_delete_usrs_stage_3.sql delete mode 100644 remove_ou_data/17_vacuum_analyze.sql create mode 100644 remove_ou_data/18_vauum_analyze.sql diff --git a/remove_ou_data/16_delete_usrs_stage_1.sql b/remove_ou_data/16_delete_usrs_stage_1.sql deleted file mode 100644 index 78c3956..0000000 --- a/remove_ou_data/16_delete_usrs_stage_1.sql +++ /dev/null @@ -1,42 +0,0 @@ --- Copyright 2015, Equinox Software, Inc. --- Author: Galen Charlton --- --- This program is free software; you can redistribute it and/or --- modify it under the terms of the GNU General Public License --- as published by the Free Software Foundation; either version 2 --- of the License, or (at your option) any later version. --- --- This program is distributed in the hope that it will be useful, --- but WITHOUT ANY WARRANTY; without even the implied warranty of --- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the --- GNU General Public License for more details. --- --- You should have received a copy of the GNU General Public License --- along with this program; if not, write to the Free Software --- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. - -\set ou_to_del ''''EXAMPLE'''' -\set ECHO all -\timing - --- creates an output file for serially deleting users, --- makes it easier than finding each problem stopping a batch --- creates a stage 2 inbetween 1 and 3 - -\t -\psql format unaligned -\o 16_delete_usrs_stage_2.sql - -SELECT 'ALTER TABLE actor.usr DISABLE RULE protect_user_delete;'; -SELECT 'DELETE FROM actor.usr WHERE id = ' || id || ';' -FROM actor.usr WHERE home_ou IN ( - SELECT (actor.org_unit_descendants(id)).id FROM actor.org_unit - WHERE shortname = :ou_to_del -); -SELECT 'ALTER TABLE actor.usr ENABLE RULE protect_user_delete;'; - -\o -\pset format aligned -\t - - diff --git a/remove_ou_data/16_delete_usrs_stage_3.sql b/remove_ou_data/16_delete_usrs_stage_3.sql deleted file mode 100644 index 09cc9d2..0000000 --- a/remove_ou_data/16_delete_usrs_stage_3.sql +++ /dev/null @@ -1,29 +0,0 @@ --- Copyright 2015, Equinox Software, Inc. --- Author: Galen Charlton --- --- This program is free software; you can redistribute it and/or --- modify it under the terms of the GNU General Public License --- as published by the Free Software Foundation; either version 2 --- of the License, or (at your option) any later version. --- --- This program is distributed in the hope that it will be useful, --- but WITHOUT ANY WARRANTY; without even the implied warranty of --- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the --- GNU General Public License for more details. --- --- You should have received a copy of the GNU General Public License --- along with this program; if not, write to the Free Software --- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. - -\set ou_to_del ''''EXAMPLE'''' -\set ECHO all -\timing - -SELECT id -FROM actor.usr WHERE home_ou IN ( - SELECT (actor.org_unit_descendants(id)).id FROM actor.org_unit - WHERE shortname IN (SELECT shortname FROM esi.ous_to_del) -); - - --- find the problems and clear them up diff --git a/remove_ou_data/16_remove_acq.sql b/remove_ou_data/16_remove_acq.sql new file mode 100644 index 0000000..d88d1b7 --- /dev/null +++ b/remove_ou_data/16_remove_acq.sql @@ -0,0 +1,30 @@ +-- Copyright 2015, Equinox Software, Inc. +-- Author: Galen Charlton +-- +-- This program is free software; you can redistribute it and/or +-- modify it under the terms of the GNU General Public License +-- as published by the Free Software Foundation; either version 2 +-- of the License, or (at your option) any later version. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program; if not, write to the Free Software +-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. + +\set ou_to_del ''''EXAMPLE'''' +\set ECHO all +\timing + +BEGIN; + +DELETE FROM acq.lineitem WHERE picklist IN (SELECT id FROM acq.picklist WHERE org_unit IN + (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del) +); + +DELETE FROM acq.picklist WHERE org_unit IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); + +COMMIT; diff --git a/remove_ou_data/17_delete_usrs_stage_1.sql b/remove_ou_data/17_delete_usrs_stage_1.sql new file mode 100644 index 0000000..25e36ff --- /dev/null +++ b/remove_ou_data/17_delete_usrs_stage_1.sql @@ -0,0 +1,42 @@ +-- Copyright 2015, Equinox Software, Inc. +-- Author: Galen Charlton +-- +-- This program is free software; you can redistribute it and/or +-- modify it under the terms of the GNU General Public License +-- as published by the Free Software Foundation; either version 2 +-- of the License, or (at your option) any later version. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program; if not, write to the Free Software +-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. + +\set ou_to_del ''''EXAMPLE'''' +\set ECHO all +\timing + +-- creates an output file for serially deleting users, +-- makes it easier than finding each problem stopping a batch +-- creates a stage 2 inbetween 1 and 3 + +\t +\psql format unaligned +\o 17_delete_usrs_stage_2.sql + +SELECT 'ALTER TABLE actor.usr DISABLE RULE protect_user_delete;'; +SELECT 'DELETE FROM actor.usr WHERE id = ' || id || ';' +FROM actor.usr WHERE home_ou IN ( + SELECT (actor.org_unit_descendants(id)).id FROM actor.org_unit + WHERE shortname = :ou_to_del +); +SELECT 'ALTER TABLE actor.usr ENABLE RULE protect_user_delete;'; + +\o +\pset format aligned +\t + + diff --git a/remove_ou_data/17_delete_usrs_stage_3.sql b/remove_ou_data/17_delete_usrs_stage_3.sql new file mode 100644 index 0000000..09cc9d2 --- /dev/null +++ b/remove_ou_data/17_delete_usrs_stage_3.sql @@ -0,0 +1,29 @@ +-- Copyright 2015, Equinox Software, Inc. +-- Author: Galen Charlton +-- +-- This program is free software; you can redistribute it and/or +-- modify it under the terms of the GNU General Public License +-- as published by the Free Software Foundation; either version 2 +-- of the License, or (at your option) any later version. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program; if not, write to the Free Software +-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. + +\set ou_to_del ''''EXAMPLE'''' +\set ECHO all +\timing + +SELECT id +FROM actor.usr WHERE home_ou IN ( + SELECT (actor.org_unit_descendants(id)).id FROM actor.org_unit + WHERE shortname IN (SELECT shortname FROM esi.ous_to_del) +); + + +-- find the problems and clear them up diff --git a/remove_ou_data/17_vacuum_analyze.sql b/remove_ou_data/17_vacuum_analyze.sql deleted file mode 100644 index 1d60fb1..0000000 --- a/remove_ou_data/17_vacuum_analyze.sql +++ /dev/null @@ -1,113 +0,0 @@ -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 ; diff --git a/remove_ou_data/18_vauum_analyze.sql b/remove_ou_data/18_vauum_analyze.sql new file mode 100644 index 0000000..1d60fb1 --- /dev/null +++ b/remove_ou_data/18_vauum_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 ; -- 1.7.2.5