On Tue, Feb 28, 2012 at 10:53 PM, Brian Fehrle <brianf@xxxxxxxxxxxxxxxxxxx> wrote: > 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. We don't do a restartpoint on the standby unless we see a checkpoint record, so that result should be impossible. So I'm guessing you're reading the stats wrong? -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
