From: | Don Seiler <don(at)seiler(dot)us> |
---|---|
To: | Adrien Nayrat <adrien(dot)nayrat(at)dalibo(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: No stats after promoting standby? |
Date: | 2017-12-04 21:35:18 |
Message-ID: | CAHJZqBC8eFDmdMcA70o1q_1-S_TKYz=wJ09OUg99qmYQEp61+g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, Dec 4, 2017 at 3:37 PM, Adrien Nayrat <adrien(dot)nayrat(at)dalibo(dot)com>
wrote:
>
> Stats are deleted after promotion :
> " The stats file is deleted at the start of recovery, so stats from
> primary and
> standby will differ; this is considered a feature, not a bug."
> https://www.postgresql.org/docs/current/static/hot-standby.html
>
> Or : https://www.postgresql.org/message-id/31781.1508448417%
> 40sss.pgh.pa.us
>
> You have to do an ANALYZE just after promotion.
>
OK good to know. Interesting point but I think I disagree about the standby
having its own stats. Until replication is broken, wouldn't the data be
identical to the primary, and so the statistics should be identical as well?
In the meantime I'll know to manually analyze.
Don.
--
Don Seiler
www.seiler.us
From | Date | Subject | |
---|---|---|---|
Next Message | Adrien Nayrat | 2017-12-04 21:37:27 | Re: No stats after promoting standby? |
Previous Message | Don Seiler | 2017-12-04 19:26:14 | No stats after promoting standby? |