Subject: Re: No stats after promoting standby?
To: Don Seiler <don@seiler.us>, pgsql-admin <pgsql-admin@postgresql.org>
References: 
 <CAHJZqBB=NPK5MmGk2xuP96yrvCY3U024n=BGkdrKsQe5BHvM9g@mail.gmail.com>
From: Adrien Nayrat <adrien.nayrat@dalibo.com>
Message-ID: <2c483dd8-e669-2fdb-3551-fb082e15b48c@dalibo.com>
Date: Mon, 4 Dec 2017 22:37:27 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.4.0
MIME-Version: 1.0
In-Reply-To: 
 <CAHJZqBB=NPK5MmGk2xuP96yrvCY3U024n=BGkdrKsQe5BHvM9g@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="9TFB6f0ekp1rb3oUs1DJVuNifElHVam35"
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--9TFB6f0ekp1rb3oUs1DJVuNifElHVam35
Content-Type: multipart/mixed; boundary="gwuuIHbILH8aUCxRq8ugPDT5KhOAdX0ln";
 protected-headers="v1"
From: Adrien Nayrat <adrien.nayrat@dalibo.com>
To: Don Seiler <don@seiler.us>, pgsql-admin <pgsql-admin@postgresql.org>
Message-ID: <2c483dd8-e669-2fdb-3551-fb082e15b48c@dalibo.com>
Subject: Re: No stats after promoting standby?
References: <CAHJZqBB=NPK5MmGk2xuP96yrvCY3U024n=BGkdrKsQe5BHvM9g@mail.gmail.com>
In-Reply-To: <CAHJZqBB=NPK5MmGk2xuP96yrvCY3U024n=BGkdrKsQe5BHvM9g@mail.gmail.com>

--gwuuIHbILH8aUCxRq8ugPDT5KhOAdX0ln
Content-Type: text/plain; charset=utf-8
Content-Language: fr-classic
Content-Transfer-Encoding: quoted-printable

On 12/04/2017 08:26 PM, Don Seiler wrote:
> Do stats not automatically get preserved when a standby is promoted? Di=
d
> something go wrong here or should I know/expect to have to manually gat=
her DB
> stats after a failover (like we do with major upgrades)?

Hi,

Stats are deleted after promotion :
" The stats file is deleted at the start of recovery, so stats from prima=
ry 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.

Regards,


--=20
Adrien NAYRAT


--gwuuIHbILH8aUCxRq8ugPDT5KhOAdX0ln--

--9TFB6f0ekp1rb3oUs1DJVuNifElHVam35
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQEzBAEBCAAdFiEEm0vCLGPoatLA5LoUsupItzJ4s38FAlolwBcACgkQsupItzJ4
s3/E1Af/XbVeK9shIleElyp59N0RX6m9Xs2C8mrI0iDFPkUl2O2X6o/I6D1GVKR/
lDhmf2mLDAo50DuwMUyQ+VWTWPIaRMNjyR+2M8JuJqhpILtBJ/wIzFepiX51PzW7
9yW8KYQf23LbQQCmXfp36ZTLJDWQGeFV6JN0VNlCYLjL/EcYjQawM+p1OtY0FDmL
lJ7nmscmlZSVitxaarOoXUnPjIKKLjmbDzrh99zwnUfjHD19YMWut8ZV5PYz8DZl
INVb6ZiYuwGFfeDrOD0PxYWcGYB5rb1CW0sUPvNXIoDs1ss/eVKbFhJ60Ep1ksQe
+maf/RZD/6C0aFznkJyTYloMnQdMfw==
=736f
-----END PGP SIGNATURE-----

--9TFB6f0ekp1rb3oUs1DJVuNifElHVam35--