are analyze statistics synced with replication?

From: Kevin Goess <kgoess(at)bepress(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: are analyze statistics synced with replication?
Date: 2014-05-15 04:46:56
Message-ID: CABZkbxh-_F1cv9E93XVDBUpwQwm0XRvwaAkM1x0VWRmExs15wA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Khangelani Gama 2014-05-15 06:19:27 Correct update statement
Previous Message Keith 2014-05-15 03:27:11 Re: what should be the best autovacuum configuration for daily partition table