From: Heikki Linnakangas <hlinnakangas@vmware.com>
To: Soni M <diptatapa@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Postgres Replaying WAL slowly
Date: Sun, 29 Jun 2014 11:31:31 +0300
Message-ID: <53AFCEE3.4080009@vmware.com> (raw)
In-Reply-To: <CAAMgDXm5Y9QPELKvCGBrFvPcuR0ENVA1tEYRcazhDSxs6xnX5w@mail.gmail.com>
References: <CAAMgDXm5Y9QPELKvCGBrFvPcuR0ENVA1tEYRcazhDSxs6xnX5w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 06/29/2014 11:14 AM, Soni M wrote:
> Everything works fine until on Thursday we have high load on master, and
> after that every streaming replica lag further behind the master. Even on
> night and weekend where all server load is low. But the slony slave is OK
> at all.
What does 'top' on the standby say? Is the startup process using 100% of
(one) CPU replaying records, or is it waiting for I/O? How large is the
database, does it fit in RAM? Any clues in the system or PostgreSQL logs?
- Heikki
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: hlinnakangas@vmware.com, diptatapa@gmail.com
Subject: Re: Postgres Replaying WAL slowly
In-Reply-To: <53AFCEE3.4080009@vmware.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox