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.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>>:
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.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
<mailto:adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>>>:
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 <mailto:adrian.klaver@xxxxxxxxxxx>
<mailto:adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
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
