I formatted correctly before sending the email. Maybe you should ask yourself if the mail server did not remove the formatting.
Well the relpages, reltuples are estimated values that can be updated with an ANALYZE.
I can not make analyze on a table whose filenode is pointing to another reference. The table is empty, just because the filenode does not point to the correct ID.
Hi. I have a rather serious problem in my database. I'll try to summarize what happened and how far I've gotten with the help of friends from the pgsql-sql list.
When I returned the copy of the drives, the records were no longer found. For example, if I make a "select count (*) from" 01052016 ".repository", the record amount will result to 0. But all the binaries are there, intact.
As I said above, with the help of friends from the pgsql-sql list, I managed to find the problem. When I did the truncate, the data was erased and the filenode was recreated and pointed to a zero file. Doing this query: select pg_relation_filenode ('01052016.repository' :: regclass), it returns me: 13741352, when the correct link (before truncate) was 5214489.
Now, doing this other query: select c. * From pg_class c Where c.relfilenode = 13741352 He returns me: