Re: are analyze statistics synced with replication?

From: Kevin Goess <kgoess(at)bepress(dot)com>
To: Dorian Hoxha <dorian(dot)hoxha(at)gmail(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 15:29:58
Message-ID: CABZkbximkujfL8Yk9dGgy2kfRLxeCQTDa9HrH-C=vhZmg9zFBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, May 15, 2014 at 6:39 AM, Dorian Hoxha <dorian(dot)hoxha(at)gmail(dot)com>wrote:

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

Yeah, that was the first thing we noticed, the cacti graph shows it took
two hours for the page cache to fill up our 64GB of RAM, but I/O didn't
stop sucking after that.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Diego Ramón Cando Díaz 2014-05-15 20:52:42 Questions about DB capabilities
Previous Message Adrian Klaver 2014-05-15 14:41:45 Re: Re: TODO: Expose parser support for decoding unicode escape literals to user