SELECT COUNT(*) FROM all_domains;
count
---------
4285115
(1 row)
DELETE FROM all_domains WHERE id_domains IN (SELECT id_domains FROM all_domains WHERE real_true = false AND proverka_true = true LIMIT 10000);
(тут для теста ставил 100 записей, они удалились, сколько надо ставить?)
VACUUM ANALYZE;
WARNING: skipping "pg_statistic" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_foreign_table" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_authid" --- only superuser can vacuum it
WARNING: skipping "pg_user_mapping" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_subscription" --- only superuser can vacuum it
WARNING: skipping "pg_largeobject" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_type" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_attribute" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_proc" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_class" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_attrdef" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_constraint" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_inherits" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_index" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_operator" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_opfamily" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_opclass" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_am" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_amop" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_amproc" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_language" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_largeobject_metadata" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_aggregate" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_statistic_ext" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_rewrite" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_trigger" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_event_trigger" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_description" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_cast" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_enum" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_namespace" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_conversion" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_depend" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_database" --- only superuser can vacuum it
WARNING: skipping "pg_db_role_setting" --- only superuser can vacuum it
WARNING: skipping "pg_tablespace" --- only superuser can vacuum it
WARNING: skipping "pg_pltemplate" --- only superuser can vacuum it
WARNING: skipping "pg_auth_members" --- only superuser can vacuum it
WARNING: skipping "pg_shdepend" --- only superuser can vacuum it
WARNING: skipping "pg_shdescription" --- only superuser can vacuum it
WARNING: skipping "pg_ts_config" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_ts_config_map" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_ts_dict" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_ts_parser" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_ts_template" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_extension" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_foreign_data_wrapper" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_foreign_server" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_policy" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_replication_origin" --- only superuser can vacuum it
WARNING: skipping "pg_default_acl" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_init_privs" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_seclabel" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_shseclabel" --- only superuser can vacuum it
WARNING: skipping "pg_collation" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_partitioned_table" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_range" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_transform" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_sequence" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_publication" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_publication_rel" --- only superuser or database owner can vacuum it
WARNING: skipping "pg_subscription_rel" --- only superuser or database owner can vacuum it
WARNING: skipping "sql_features" --- only table or database owner can vacuum it
WARNING: skipping "sql_implementation_info" --- only table or database owner can vacuum it
WARNING: skipping "sql_languages" --- only table or database owner can vacuum it
WARNING: skipping "sql_packages" --- only table or database owner can vacuum it
WARNING: skipping "sql_parts" --- only table or database owner can vacuum it
WARNING: skipping "sql_sizing" --- only table or database owner can vacuum it
WARNING: skipping "sql_sizing_profiles" --- only table or database owner can vacuum it
VACUUM
Text paste