From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | tel medola <tel(dot)medola(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Redo the filenode link in tablespace |
Date: | 2017-06-01 13:29:03 |
Message-ID: | 58bebee0-38f0-7a9b-a7fe-d7dd418b6918@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 06/01/2017 03:47 AM, tel medola wrote:
> Did you get any help with this?
> /I formatted correctly before sending the email. Maybe you should ask
> yourself if the mail server did not remove the formatting./
I was talking about help with your relfilenode issue, I learned to deal
with the formatting awhile ago.
> /
> /
> 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./
Understood, I was just saying that if you could get the table pointing
at the right relfilenode the other values would be synced up with an
ANALYZE.
At this point it is time to just try something. You have file level
backups of the various backups, so you can restore that if something
goes wrong, correct?
For 01052016.repositorio with current pg_class entry of relfilenode of
13741352, change that back to the old entry of 5214489.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2017-06-01 14:45:17 | Re: Slow query plan used |
Previous Message | Wetzel, Juergen (Juergen) | 2017-06-01 12:07:19 | Re: Slow query plan used |