Search Postgresql Archives

Re: Redo the filenode link in tablespace

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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) 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>>:

    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>




--
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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux