Сравнение постов
Различия между постами
#129150 (10.11.2019 03:33)
и
#211387 (06.08.2021 18:52).
| 1 | SELECT COUNT(*) FROM all_domains; | |
| 2 | count | |
| 3 | --------- | |
| 4 | 4285115 | |
| 5 | (1 row) | |
| 6 | ||
| 7 | DELETE FROM all_domains WHERE id_domains IN (SELECT id_domains FROM all_domains WHERE real_true = false AND proverka_true = true LIMIT 10000); | |
| 8 | (тут для теста ставил 100 записей, они удалились, сколько надо ставить?) | |
| 9 | VACUUM ANALYZE; | |
| 10 | WARNING: skipping "pg_statistic" --- only superuser or database owner can vacuum it | |
| 11 | WARNING: skipping "pg_foreign_table" --- only superuser or database owner can vacuum it | |
| 12 | WARNING: skipping "pg_authid" --- only superuser can vacuum it | |
| 13 | WARNING: skipping "pg_user_mapping" --- only superuser or database owner can vacuum it | |
| 14 | WARNING: skipping "pg_subscription" --- only superuser can vacuum it | |
| 15 | WARNING: skipping "pg_largeobject" --- only superuser or database owner can vacuum it | |
| 16 | WARNING: skipping "pg_type" --- only superuser or database owner can vacuum it | |
| 17 | WARNING: skipping "pg_attribute" --- only superuser or database owner can vacuum it | |
| 18 | WARNING: skipping "pg_proc" --- only superuser or database owner can vacuum it | |
| 19 | WARNING: skipping "pg_class" --- only superuser or database owner can vacuum it | |
| 20 | WARNING: skipping "pg_attrdef" --- only superuser or database owner can vacuum it | |
| 21 | WARNING: skipping "pg_constraint" --- only superuser or database owner can vacuum it | |
| 22 | WARNING: skipping "pg_inherits" --- only superuser or database owner can vacuum it | |
| 23 | WARNING: skipping "pg_index" --- only superuser or database owner can vacuum it | |
| 24 | WARNING: skipping "pg_operator" --- only superuser or database owner can vacuum it | |
| 25 | WARNING: skipping "pg_opfamily" --- only superuser or database owner can vacuum it | |
| 26 | WARNING: skipping "pg_opclass" --- only superuser or database owner can vacuum it | |
| 27 | WARNING: skipping "pg_am" --- only superuser or database owner can vacuum it | |
| 28 | WARNING: skipping "pg_amop" --- only superuser or database owner can vacuum it | |
| 29 | WARNING: skipping "pg_amproc" --- only superuser or database owner can vacuum it | |
| 30 | WARNING: skipping "pg_language" --- only superuser or database owner can vacuum it | |
| 31 | WARNING: skipping "pg_largeobject_metadata" --- only superuser or database owner can vacuum it | |
| 32 | WARNING: skipping "pg_aggregate" --- only superuser or database owner can vacuum it | |
| 33 | WARNING: skipping "pg_statistic_ext" --- only superuser or database owner can vacuum it | |
| 34 | WARNING: skipping "pg_rewrite" --- only superuser or database owner can vacuum it | |
| 35 | WARNING: skipping "pg_trigger" --- only superuser or database owner can vacuum it | |
| 36 | WARNING: skipping "pg_event_trigger" --- only superuser or database owner can vacuum it | |
| 37 | WARNING: skipping "pg_description" --- only superuser or database owner can vacuum it | |
| 38 | WARNING: skipping "pg_cast" --- only superuser or database owner can vacuum it | |
| 39 | WARNING: skipping "pg_enum" --- only superuser or database owner can vacuum it | |
| 40 | WARNING: skipping "pg_namespace" --- only superuser or database owner can vacuum it | |
| 41 | WARNING: skipping "pg_conversion" --- only superuser or database owner can vacuum it | |
| 42 | WARNING: skipping "pg_depend" --- only superuser or database owner can vacuum it | |
| 43 | WARNING: skipping "pg_database" --- only superuser can vacuum it | |
| 44 | WARNING: skipping "pg_db_role_setting" --- only superuser can vacuum it | |
| 45 | WARNING: skipping "pg_tablespace" --- only superuser can vacuum it | |
| 46 | WARNING: skipping "pg_pltemplate" --- only superuser can vacuum it | |
| 47 | WARNING: skipping "pg_auth_members" --- only superuser can vacuum it | |
| 48 | WARNING: skipping "pg_shdepend" --- only superuser can vacuum it | |
| 49 | WARNING: skipping "pg_shdescription" --- only superuser can vacuum it | |
| 50 | WARNING: skipping "pg_ts_config" --- only superuser or database owner can vacuum it | |
| 51 | WARNING: skipping "pg_ts_config_map" --- only superuser or database owner can vacuum it | |
| 52 | WARNING: skipping "pg_ts_dict" --- only superuser or database owner can vacuum it | |
| 53 | WARNING: skipping "pg_ts_parser" --- only superuser or database owner can vacuum it | |
| 54 | WARNING: skipping "pg_ts_template" --- only superuser or database owner can vacuum it | |
| 55 | WARNING: skipping "pg_extension" --- only superuser or database owner can vacuum it | |
| 56 | WARNING: skipping "pg_foreign_data_wrapper" --- only superuser or database owner can vacuum it | |
| 57 | WARNING: skipping "pg_foreign_server" --- only superuser or database owner can vacuum it | |
| 58 | WARNING: skipping "pg_policy" --- only superuser or database owner can vacuum it | |
| 59 | WARNING: skipping "pg_replication_origin" --- only superuser can vacuum it | |
| 60 | WARNING: skipping "pg_default_acl" --- only superuser or database owner can vacuum it | |
| 61 | WARNING: skipping "pg_init_privs" --- only superuser or database owner can vacuum it | |
| 62 | WARNING: skipping "pg_seclabel" --- only superuser or database owner can vacuum it | |
| 63 | WARNING: skipping "pg_shseclabel" --- only superuser can vacuum it | |
| 64 | WARNING: skipping "pg_collation" --- only superuser or database owner can vacuum it | |
| 65 | WARNING: skipping "pg_partitioned_table" --- only superuser or database owner can vacuum it | |
| 66 | WARNING: skipping "pg_range" --- only superuser or database owner can vacuum it | |
| 67 | WARNING: skipping "pg_transform" --- only superuser or database owner can vacuum it | |
| 68 | WARNING: skipping "pg_sequence" --- only superuser or database owner can vacuum it | |
| 69 | WARNING: skipping "pg_publication" --- only superuser or database owner can vacuum it | |
| 70 | WARNING: skipping "pg_publication_rel" --- only superuser or database owner can vacuum it | |
| 71 | WARNING: skipping "pg_subscription_rel" --- only superuser or database owner can vacuum it | |
| 72 | WARNING: skipping "sql_features" --- only table or database owner can vacuum it | |
| 73 | WARNING: skipping "sql_implementation_info" --- only table or database owner can vacuum it | |
| 74 | WARNING: skipping "sql_languages" --- only table or database owner can vacuum it | |
| 75 | WARNING: skipping "sql_packages" --- only table or database owner can vacuum it | |
| 76 | WARNING: skipping "sql_parts" --- only table or database owner can vacuum it | |
| 77 | WARNING: skipping "sql_sizing" --- only table or database owner can vacuum it | |
| 78 | WARNING: skipping "sql_sizing_profiles" --- only table or database owner can vacuum it |