Done.
I followed the steps below after reconnecting the filenode:
Select * from "05122016".repositorio
Count -> 0
Then, I execute the commands:
Analyze "05122016".repositorio;
Count -> 0
Reindex "05122016".repositorio;
Count -> 1509046
Yes!
But...
select * from "05122016".repository where id_documento = '{A647885D-9738-4617-ACE6-6351F6ADD341}'
Returns the error below:
Missing chunk number 0 for toast value 10259186 in pg_toast_9277966
I tried to do the commands below, but the error persists:
REINDEX table pg_toast.pg_toast_9277966;
VACUUM ANALYZE pg_toast_9277966
VACUUM ANALYZE "05122016".repositorio;
REINDEX TABLE pg_statistic;
I read in the forum to run the command:
Delete from pg_statistic;
Reindex table pg_statistic;
Vacuum analyze;
Is it okay to delete the pg_statistic table?