Re: are analyze statistics synced with replication?

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

In response to

Responses

Browse pgsql-general by date

  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