Re: [GENERAL] Redo the filenode link in tablespace

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@aklaver.com