Lets go: In my plsql: rai=# select oid, * from pg_class where relfilenode = 5214489;
Result: oid | relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relispopulated | relfrozenxid | relminmxid | relacl | reloptions ---------+-------------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+--------------+---------------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+----------------+--------------+------------+--------+------------ 5214489 | repositorio | 5205962 | 5214491 | 0 | 10 | 0 | 5214489 | 5205910 | 79303 | 1.31566e+006 | 79303 | 5214493 | 0 | t | f | p | r | 7 | 0 | f | t | f | f | f | t | 9360288 | 1 | | (1 registro) Ok? 2017-06-05 20:13 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/05/2017 04:07 PM, tel medola wrote: > >> Hi, >> attachment. >> >> select: >> select * from pg_class where relfilenode = 5214489 >> > > Next, what do you get from: > > In psql > => \x > Expanded display is on. > > select oid, * from pg_class where oid = 5214493; > > No need to create an attachment, just cut and paste into message. > > > >> Thanks >> >> 2017-06-05 16:02 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com >> <mailto:adrian.kla...@aklaver.com>>: >> >> On 06/05/2017 11:55 AM, tel medola wrote: >> >> show? >> /Yes/ >> >> >> Yes, what? >> >> Please run the command as shown: >> >> select * from pg_class where relfilenode = 5214489; >> >> and show the result. >> >> >> 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 <mailto:adrian.kla...@aklaver.com> >> <mailto:adrian.kla...@aklaver.com >> >> <mailto: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 <mailto:adrian.kla...@aklaver.com> >> <mailto:adrian.kla...@aklaver.com >> <mailto:adrian.kla...@aklaver.com>> >> >> >> >> >> -- Adrian Klaver >> adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
