Re: Hot standby having high requested checkpoints?
| От | Simon Riggs |
|---|---|
| Тема | Re: Hot standby having high requested checkpoints? |
| Дата | |
| Msg-id | CA+U5nMKcy_wkzJdpwsjyaa76ucyw0FkDhdXnMCypbAwPF0JSEQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Hot standby having high requested checkpoints? (Brian Fehrle <brianf@consistentstate.com>) |
| Ответы |
Re: Hot standby having high requested checkpoints?
|
| Список | pgsql-admin |
On Tue, Feb 28, 2012 at 10:53 PM, Brian Fehrle <brianf@consistentstate.com> 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
В списке pgsql-admin по дате отправления: