Received-SPF: pass (google.com: domain of brianf@consistentstate.com
	designates 10.68.211.202 as permitted sender)
	client-ip=10.68.211.202;
Message-ID: <4F4E40E5.9040006@consistentstate.com>
Date: Wed, 29 Feb 2012 08:14:45 -0700
From: Brian Fehrle <brianf@consistentstate.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US;
	rv:1.9.2.26) Gecko/20120129 Lightning/1.0b2 Thunderbird/3.1.18
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Hot standby having high requested checkpoints?
References: <4F4D5AE0.9020204@consistentstate.com>
	<CAHGQGwF+g6c+eU1M9Lq-PfeEz8V525p1utyBUs8wj2xh7k=_Rw@mail.gmail.com>
In-Reply-To: 
 <CAHGQGwF+g6c+eU1M9Lq-PfeEz8V525p1utyBUs8wj2xh7k=_Rw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I am taking periodic snapshots from the system view 'pg_stat_bgwriter' 
from both the master and the hot standby.

- Brian F

On 02/28/2012 09:22 PM, Fujii Masao wrote:
> On Wed, Feb 29, 2012 at 7:53 AM, Brian Fehrle
> <brianf@consistentstate.com>  wrote:
>> Hi all,
>>
>> I have two PostgreSQL 9.0.5 clusters, one is a master and the other is a hot
>> standby via streaming replication. I'm monitoring some stats on each and I'm
>> noticing something very odd. On the master, I get between 2 and 4 requested
>> checkpoints per hour, but on the hot standby I'm seeing between 200 and 300
>> requested checkpoints per hour.
> How did you get that information? Enable log_checkpoints?
>
> Regards,
>