From: | Dorian Hoxha <dorian(dot)hoxha(at)gmail(dot)com> |
---|---|
To: | Kevin Goess <kgoess(at)bepress(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: are analyze statistics synced with replication? |
Date: | 2014-05-15 13:39:39 |
Message-ID: | CANsFX065Z19bYxaf3ZSyS3VE_G_wz5j5zZ0U_Qvf472B7q_OBQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If you don't do read queries on the slave than it will not have hot
data/pages/rows/tables/indexes in ram like the primary ? (it smoked weed
and was happy doing nothing so it was happy, but when responsibility came
(being promoted to master) it failed hard)
On Thu, May 15, 2014 at 6:46 AM, Kevin Goess <kgoess(at)bepress(dot)com> wrote:
> We have a master/slave setup with replication. Today we failed over to
> the slave and saw disk I/O go through the roof.
>
> Are the pg_statistic statistics synced along with streaming replication?
> Are you expected to have to do a vacuum analyze after failing over? That's
> what we're trying now to see if it makes a difference. Our next step will
> be to fall back to the first host and see where this one went wrong
> (society? lax discipline at home? the wrong sort of friends?)
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-05-15 13:56:13 | Re: TODO: Expose parser support for decoding unicode escape literals to user |
Previous Message | Khangelani Gama | 2014-05-15 09:22:16 | Re: Correct update statement |