On 06/05/2017 07:17 AM, tel medola wrote:
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
What does:
select * from pg_class where relfilenode = 5214489;
show?
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?
Do not delete the pg_statistic table. I would not even delete from it.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
