Primeiro Muito Obrigado Pelas dicas Realmente ajudaram. Entretanto agora estou enfrentando problemas o mesmo problema em outra tabela e não mais em um índice com antes.
Segue log da reindexação: bd=> REINDEX DATABASE nfe FORCE; NOTICE: table "pg_class" was reindexed NOTICE: table "sql_features" was reindexed NOTICE: table "sql_implementation_info" was reindexed NOTICE: table "pg_statistic" was reindexed NOTICE: table "sql_languages" was reindexed NOTICE: table "sql_packages" was reindexed NOTICE: table "sql_parts" was reindexed NOTICE: table "sql_sizing" was reindexed NOTICE: table "sql_sizing_profiles" was reindexed NOTICE: table "pg_ts_config" was reindexed NOTICE: table "pg_ts_config_map" was reindexed NOTICE: table "pg_ts_dict" was reindexed NOTICE: table "pg_ts_parser" was reindexed NOTICE: table "pg_ts_template" was reindexed NOTICE: table "pg_type" was reindexed NOTICE: table "pg_attribute" was reindexed NOTICE: table "pg_proc" was reindexed NOTICE: table "pg_autovacuum" was reindexed NOTICE: table "pg_attrdef" was reindexed NOTICE: table "pg_constraint" was reindexed NOTICE: table "pg_inherits" was reindexed NOTICE: table "pg_index" was reindexed NOTICE: table "pg_operator" was reindexed NOTICE: table "pg_opfamily" was reindexed NOTICE: table "pg_opclass" was reindexed NOTICE: table "pg_am" was reindexed NOTICE: table "pg_amop" was reindexed NOTICE: table "pg_amproc" was reindexed NOTICE: table "pg_language" was reindexed NOTICE: table "pg_largeobject" was reindexed NOTICE: table "pg_aggregate" was reindexed NOTICE: table "pg_rewrite" was reindexed NOTICE: table "pg_trigger" was reindexed NOTICE: table "pg_description" was reindexed NOTICE: table "pg_cast" was reindexed NOTICE: table "pg_enum" was reindexed NOTICE: table "pg_namespace" was reindexed NOTICE: table "pg_conversion" was reindexed NOTICE: table "pg_depend" was reindexed NOTICE: table "log" was reindexed NOTICE: table "retdoc" was reindexed NOTICE: table "menu" was reindexed NOTICE: table "perfilfila" was reindexed NOTICE: table "usuario" was reindexed NOTICE: table "perfil" was reindexed NOTICE: table "entdoc" was reindexed NOTICE: table "filanfe" was reindexed ERROR: invalid page header in block 84 of relation "historico" Gostaria de saber se tem como forçar a reindexação? Cristiano O. Ferreira.
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
