Disk reads when using streaming replication?

From: Dave Johansen <davejohansen(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Disk reads when using streaming replication?
Date: 2016-04-05 18:05:56
Message-ID: CAAcYxUd=SQp4a6RHxRboxT4kbyD0ROyv3HvZRg0WYMn5xjGkVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We have a Postgres 9.2 configuration with streaming replication. During
periods when you're running nothing on the slave but the replication, we
notice spikes in disk reads.

What could be the cause of this?
Are all of the WAL files written to disk and then read before being applied?
Or can something cause the WAL files to have to be written to disk and then
read before being applied?

Thanks,
Dave

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Brunnengräber 2016-04-07 18:14:07 postgres wal sender replication timeout during pg_basebackup
Previous Message Victor Yegorov 2016-04-05 05:58:49 Re: [INFO] - vm.dirty_ratio/background_ratio