show?
*Yes*
Do not delete the pg_statistic table. I would not even delete from it.
*Sorry, I already deleted it. I looked for something official and found in
the site in postgres the reference that the delete could be done
(https://www.postgresql.org/docs/9.1/static/release-7-4-2.html
<https://www.postgresql.org/docs/9.1/static/release-7-4-2.html>) and I
ended up doing it. Now I'm running a vacuum analyze across the base.*
2017-06-05 15:41 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>:
> 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.kla...@aklaver.com
>
